{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "import tushare as ts"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "#获取深圳成指k线数据\n",
    "df = ts.get_hist_data('sh',start='2018-07-01',end='2018-07-30')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv(\"df001.csv\")#保存文件"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>open</th>\n",
       "      <th>high</th>\n",
       "      <th>close</th>\n",
       "      <th>low</th>\n",
       "      <th>volume</th>\n",
       "      <th>price_change</th>\n",
       "      <th>p_change</th>\n",
       "      <th>ma5</th>\n",
       "      <th>ma10</th>\n",
       "      <th>ma20</th>\n",
       "      <th>v_ma5</th>\n",
       "      <th>v_ma10</th>\n",
       "      <th>v_ma20</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2018-06-14</th>\n",
       "      <td>21.76</td>\n",
       "      <td>21.94</td>\n",
       "      <td>21.68</td>\n",
       "      <td>21.56</td>\n",
       "      <td>15457.00</td>\n",
       "      <td>-0.07</td>\n",
       "      <td>-0.32</td>\n",
       "      <td>21.894</td>\n",
       "      <td>21.997</td>\n",
       "      <td>22.586</td>\n",
       "      <td>17098.10</td>\n",
       "      <td>24382.83</td>\n",
       "      <td>35231.77</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-13</th>\n",
       "      <td>22.00</td>\n",
       "      <td>22.14</td>\n",
       "      <td>21.76</td>\n",
       "      <td>21.74</td>\n",
       "      <td>15149.00</td>\n",
       "      <td>-0.32</td>\n",
       "      <td>-1.45</td>\n",
       "      <td>22.024</td>\n",
       "      <td>22.037</td>\n",
       "      <td>22.687</td>\n",
       "      <td>20505.85</td>\n",
       "      <td>25793.33</td>\n",
       "      <td>36796.97</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-12</th>\n",
       "      <td>21.94</td>\n",
       "      <td>22.15</td>\n",
       "      <td>22.08</td>\n",
       "      <td>21.77</td>\n",
       "      <td>16061.00</td>\n",
       "      <td>0.14</td>\n",
       "      <td>0.64</td>\n",
       "      <td>22.208</td>\n",
       "      <td>22.030</td>\n",
       "      <td>22.810</td>\n",
       "      <td>30120.82</td>\n",
       "      <td>30269.81</td>\n",
       "      <td>39196.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-11</th>\n",
       "      <td>22.01</td>\n",
       "      <td>22.16</td>\n",
       "      <td>21.95</td>\n",
       "      <td>21.81</td>\n",
       "      <td>15324.49</td>\n",
       "      <td>-0.06</td>\n",
       "      <td>-0.27</td>\n",
       "      <td>22.198</td>\n",
       "      <td>22.114</td>\n",
       "      <td>22.942</td>\n",
       "      <td>30760.06</td>\n",
       "      <td>31866.32</td>\n",
       "      <td>45781.87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-08</th>\n",
       "      <td>22.16</td>\n",
       "      <td>22.16</td>\n",
       "      <td>22.00</td>\n",
       "      <td>21.81</td>\n",
       "      <td>23499.00</td>\n",
       "      <td>-0.32</td>\n",
       "      <td>-1.43</td>\n",
       "      <td>22.154</td>\n",
       "      <td>22.229</td>\n",
       "      <td>23.080</td>\n",
       "      <td>31322.16</td>\n",
       "      <td>36495.50</td>\n",
       "      <td>50098.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-07</th>\n",
       "      <td>22.88</td>\n",
       "      <td>22.88</td>\n",
       "      <td>22.33</td>\n",
       "      <td>22.23</td>\n",
       "      <td>32495.78</td>\n",
       "      <td>-0.29</td>\n",
       "      <td>-1.28</td>\n",
       "      <td>22.100</td>\n",
       "      <td>22.406</td>\n",
       "      <td>23.160</td>\n",
       "      <td>31667.56</td>\n",
       "      <td>45713.75</td>\n",
       "      <td>50083.74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-06</th>\n",
       "      <td>23.10</td>\n",
       "      <td>23.23</td>\n",
       "      <td>22.68</td>\n",
       "      <td>22.48</td>\n",
       "      <td>63223.83</td>\n",
       "      <td>0.65</td>\n",
       "      <td>2.95</td>\n",
       "      <td>22.050</td>\n",
       "      <td>22.501</td>\n",
       "      <td>23.232</td>\n",
       "      <td>31080.80</td>\n",
       "      <td>44615.07</td>\n",
       "      <td>49943.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-05</th>\n",
       "      <td>21.73</td>\n",
       "      <td>22.05</td>\n",
       "      <td>22.03</td>\n",
       "      <td>21.69</td>\n",
       "      <td>19257.19</td>\n",
       "      <td>0.30</td>\n",
       "      <td>1.38</td>\n",
       "      <td>21.852</td>\n",
       "      <td>22.567</td>\n",
       "      <td>23.284</td>\n",
       "      <td>30418.80</td>\n",
       "      <td>40928.37</td>\n",
       "      <td>48503.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-04</th>\n",
       "      <td>21.82</td>\n",
       "      <td>22.07</td>\n",
       "      <td>21.73</td>\n",
       "      <td>21.53</td>\n",
       "      <td>18135.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>22.030</td>\n",
       "      <td>22.746</td>\n",
       "      <td>23.380</td>\n",
       "      <td>32972.58</td>\n",
       "      <td>42212.66</td>\n",
       "      <td>50242.23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-01</th>\n",
       "      <td>22.12</td>\n",
       "      <td>22.12</td>\n",
       "      <td>21.73</td>\n",
       "      <td>21.61</td>\n",
       "      <td>25226.00</td>\n",
       "      <td>-0.33</td>\n",
       "      <td>-1.50</td>\n",
       "      <td>22.304</td>\n",
       "      <td>22.968</td>\n",
       "      <td>23.471</td>\n",
       "      <td>41668.83</td>\n",
       "      <td>44725.76</td>\n",
       "      <td>51484.17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-31</th>\n",
       "      <td>21.88</td>\n",
       "      <td>22.25</td>\n",
       "      <td>22.08</td>\n",
       "      <td>21.80</td>\n",
       "      <td>29562.00</td>\n",
       "      <td>0.40</td>\n",
       "      <td>1.84</td>\n",
       "      <td>22.712</td>\n",
       "      <td>23.174</td>\n",
       "      <td>23.558</td>\n",
       "      <td>59759.93</td>\n",
       "      <td>46080.70</td>\n",
       "      <td>51877.96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-30</th>\n",
       "      <td>22.48</td>\n",
       "      <td>22.68</td>\n",
       "      <td>21.69</td>\n",
       "      <td>21.66</td>\n",
       "      <td>59913.80</td>\n",
       "      <td>-1.22</td>\n",
       "      <td>-5.33</td>\n",
       "      <td>22.952</td>\n",
       "      <td>23.337</td>\n",
       "      <td>23.640</td>\n",
       "      <td>58149.33</td>\n",
       "      <td>47800.62</td>\n",
       "      <td>52569.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-29</th>\n",
       "      <td>23.04</td>\n",
       "      <td>23.24</td>\n",
       "      <td>22.92</td>\n",
       "      <td>22.82</td>\n",
       "      <td>32026.12</td>\n",
       "      <td>-0.17</td>\n",
       "      <td>-0.74</td>\n",
       "      <td>23.282</td>\n",
       "      <td>23.589</td>\n",
       "      <td>23.710</td>\n",
       "      <td>51437.94</td>\n",
       "      <td>48122.69</td>\n",
       "      <td>51903.48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-28</th>\n",
       "      <td>23.32</td>\n",
       "      <td>23.63</td>\n",
       "      <td>23.10</td>\n",
       "      <td>23.01</td>\n",
       "      <td>61616.24</td>\n",
       "      <td>-0.65</td>\n",
       "      <td>-2.74</td>\n",
       "      <td>23.462</td>\n",
       "      <td>23.769</td>\n",
       "      <td>23.763</td>\n",
       "      <td>51452.74</td>\n",
       "      <td>59697.42</td>\n",
       "      <td>52007.91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-25</th>\n",
       "      <td>24.21</td>\n",
       "      <td>25.00</td>\n",
       "      <td>23.77</td>\n",
       "      <td>23.72</td>\n",
       "      <td>115681.51</td>\n",
       "      <td>0.48</td>\n",
       "      <td>2.06</td>\n",
       "      <td>23.632</td>\n",
       "      <td>23.930</td>\n",
       "      <td>23.792</td>\n",
       "      <td>47782.69</td>\n",
       "      <td>63701.41</td>\n",
       "      <td>50834.62</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-24</th>\n",
       "      <td>23.46</td>\n",
       "      <td>23.55</td>\n",
       "      <td>23.28</td>\n",
       "      <td>23.26</td>\n",
       "      <td>21509.00</td>\n",
       "      <td>-0.07</td>\n",
       "      <td>-0.30</td>\n",
       "      <td>23.636</td>\n",
       "      <td>23.914</td>\n",
       "      <td>23.800</td>\n",
       "      <td>32401.47</td>\n",
       "      <td>54453.74</td>\n",
       "      <td>47065.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-23</th>\n",
       "      <td>23.63</td>\n",
       "      <td>23.70</td>\n",
       "      <td>23.34</td>\n",
       "      <td>23.32</td>\n",
       "      <td>26356.83</td>\n",
       "      <td>-0.35</td>\n",
       "      <td>-1.48</td>\n",
       "      <td>23.722</td>\n",
       "      <td>23.962</td>\n",
       "      <td>23.825</td>\n",
       "      <td>37451.90</td>\n",
       "      <td>55272.32</td>\n",
       "      <td>48358.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-22</th>\n",
       "      <td>23.82</td>\n",
       "      <td>24.09</td>\n",
       "      <td>23.82</td>\n",
       "      <td>23.55</td>\n",
       "      <td>32100.10</td>\n",
       "      <td>-0.11</td>\n",
       "      <td>-0.46</td>\n",
       "      <td>23.896</td>\n",
       "      <td>24.000</td>\n",
       "      <td>23.818</td>\n",
       "      <td>44807.44</td>\n",
       "      <td>56078.54</td>\n",
       "      <td>49073.87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-21</th>\n",
       "      <td>23.99</td>\n",
       "      <td>24.19</td>\n",
       "      <td>23.95</td>\n",
       "      <td>23.71</td>\n",
       "      <td>43266.00</td>\n",
       "      <td>0.15</td>\n",
       "      <td>0.63</td>\n",
       "      <td>24.076</td>\n",
       "      <td>24.013</td>\n",
       "      <td>23.792</td>\n",
       "      <td>67942.10</td>\n",
       "      <td>58271.81</td>\n",
       "      <td>50561.21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-18</th>\n",
       "      <td>23.50</td>\n",
       "      <td>23.90</td>\n",
       "      <td>23.79</td>\n",
       "      <td>23.21</td>\n",
       "      <td>38775.43</td>\n",
       "      <td>0.08</td>\n",
       "      <td>0.34</td>\n",
       "      <td>24.228</td>\n",
       "      <td>23.974</td>\n",
       "      <td>23.809</td>\n",
       "      <td>79620.13</td>\n",
       "      <td>58242.57</td>\n",
       "      <td>50828.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-17</th>\n",
       "      <td>24.01</td>\n",
       "      <td>24.30</td>\n",
       "      <td>23.71</td>\n",
       "      <td>23.69</td>\n",
       "      <td>46761.13</td>\n",
       "      <td>-0.51</td>\n",
       "      <td>-2.11</td>\n",
       "      <td>24.192</td>\n",
       "      <td>23.941</td>\n",
       "      <td>23.828</td>\n",
       "      <td>76506.01</td>\n",
       "      <td>57675.21</td>\n",
       "      <td>52611.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-16</th>\n",
       "      <td>24.50</td>\n",
       "      <td>24.52</td>\n",
       "      <td>24.21</td>\n",
       "      <td>24.03</td>\n",
       "      <td>63134.55</td>\n",
       "      <td>-0.51</td>\n",
       "      <td>-2.06</td>\n",
       "      <td>24.202</td>\n",
       "      <td>23.943</td>\n",
       "      <td>23.860</td>\n",
       "      <td>73092.75</td>\n",
       "      <td>57339.08</td>\n",
       "      <td>53277.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-15</th>\n",
       "      <td>25.49</td>\n",
       "      <td>25.60</td>\n",
       "      <td>24.72</td>\n",
       "      <td>24.49</td>\n",
       "      <td>147773.38</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>24.104</td>\n",
       "      <td>23.830</td>\n",
       "      <td>23.890</td>\n",
       "      <td>67349.64</td>\n",
       "      <td>55684.26</td>\n",
       "      <td>55653.07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-14</th>\n",
       "      <td>23.59</td>\n",
       "      <td>24.95</td>\n",
       "      <td>24.71</td>\n",
       "      <td>23.50</td>\n",
       "      <td>101656.17</td>\n",
       "      <td>1.09</td>\n",
       "      <td>4.62</td>\n",
       "      <td>23.950</td>\n",
       "      <td>23.757</td>\n",
       "      <td>23.949</td>\n",
       "      <td>48601.51</td>\n",
       "      <td>44318.40</td>\n",
       "      <td>52074.44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-11</th>\n",
       "      <td>23.91</td>\n",
       "      <td>23.91</td>\n",
       "      <td>23.61</td>\n",
       "      <td>23.44</td>\n",
       "      <td>23204.80</td>\n",
       "      <td>-0.16</td>\n",
       "      <td>-0.67</td>\n",
       "      <td>23.720</td>\n",
       "      <td>23.654</td>\n",
       "      <td>24.007</td>\n",
       "      <td>36865.01</td>\n",
       "      <td>37967.84</td>\n",
       "      <td>51474.99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-10</th>\n",
       "      <td>23.70</td>\n",
       "      <td>23.92</td>\n",
       "      <td>23.76</td>\n",
       "      <td>23.65</td>\n",
       "      <td>29694.83</td>\n",
       "      <td>0.04</td>\n",
       "      <td>0.17</td>\n",
       "      <td>23.690</td>\n",
       "      <td>23.685</td>\n",
       "      <td>24.162</td>\n",
       "      <td>38844.42</td>\n",
       "      <td>39676.99</td>\n",
       "      <td>60099.05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-09</th>\n",
       "      <td>23.72</td>\n",
       "      <td>23.92</td>\n",
       "      <td>23.72</td>\n",
       "      <td>23.67</td>\n",
       "      <td>34419.00</td>\n",
       "      <td>-0.22</td>\n",
       "      <td>-0.92</td>\n",
       "      <td>23.684</td>\n",
       "      <td>23.688</td>\n",
       "      <td>24.284</td>\n",
       "      <td>41585.42</td>\n",
       "      <td>41444.61</td>\n",
       "      <td>69127.78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-08</th>\n",
       "      <td>23.60</td>\n",
       "      <td>23.95</td>\n",
       "      <td>23.95</td>\n",
       "      <td>23.39</td>\n",
       "      <td>54032.76</td>\n",
       "      <td>0.38</td>\n",
       "      <td>1.61</td>\n",
       "      <td>23.556</td>\n",
       "      <td>23.635</td>\n",
       "      <td>24.455</td>\n",
       "      <td>44018.89</td>\n",
       "      <td>42069.20</td>\n",
       "      <td>76832.94</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-07</th>\n",
       "      <td>23.50</td>\n",
       "      <td>23.65</td>\n",
       "      <td>23.56</td>\n",
       "      <td>23.10</td>\n",
       "      <td>42973.67</td>\n",
       "      <td>0.07</td>\n",
       "      <td>0.30</td>\n",
       "      <td>23.564</td>\n",
       "      <td>23.570</td>\n",
       "      <td>24.564</td>\n",
       "      <td>40035.29</td>\n",
       "      <td>42850.62</td>\n",
       "      <td>80910.98</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-04</th>\n",
       "      <td>23.75</td>\n",
       "      <td>23.96</td>\n",
       "      <td>23.46</td>\n",
       "      <td>23.42</td>\n",
       "      <td>33101.83</td>\n",
       "      <td>-0.27</td>\n",
       "      <td>-1.14</td>\n",
       "      <td>23.588</td>\n",
       "      <td>23.644</td>\n",
       "      <td>24.678</td>\n",
       "      <td>39070.66</td>\n",
       "      <td>43414.29</td>\n",
       "      <td>87868.78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-09-08</th>\n",
       "      <td>12.89</td>\n",
       "      <td>13.98</td>\n",
       "      <td>13.85</td>\n",
       "      <td>12.67</td>\n",
       "      <td>60627.79</td>\n",
       "      <td>1.09</td>\n",
       "      <td>8.54</td>\n",
       "      <td>13.478</td>\n",
       "      <td>15.088</td>\n",
       "      <td>17.924</td>\n",
       "      <td>68429.43</td>\n",
       "      <td>80555.14</td>\n",
       "      <td>103801.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-09-07</th>\n",
       "      <td>12.92</td>\n",
       "      <td>13.38</td>\n",
       "      <td>12.77</td>\n",
       "      <td>12.63</td>\n",
       "      <td>52490.04</td>\n",
       "      <td>0.37</td>\n",
       "      <td>2.98</td>\n",
       "      <td>14.000</td>\n",
       "      <td>15.739</td>\n",
       "      <td>18.131</td>\n",
       "      <td>79869.39</td>\n",
       "      <td>88312.10</td>\n",
       "      <td>104161.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-09-02</th>\n",
       "      <td>12.30</td>\n",
       "      <td>14.11</td>\n",
       "      <td>12.36</td>\n",
       "      <td>12.30</td>\n",
       "      <td>70201.74</td>\n",
       "      <td>-1.10</td>\n",
       "      <td>-8.17</td>\n",
       "      <td>14.440</td>\n",
       "      <td>16.591</td>\n",
       "      <td>18.360</td>\n",
       "      <td>96977.99</td>\n",
       "      <td>98537.72</td>\n",
       "      <td>104567.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-09-01</th>\n",
       "      <td>14.78</td>\n",
       "      <td>14.78</td>\n",
       "      <td>13.46</td>\n",
       "      <td>13.46</td>\n",
       "      <td>78985.85</td>\n",
       "      <td>-1.50</td>\n",
       "      <td>-10.03</td>\n",
       "      <td>15.080</td>\n",
       "      <td>17.434</td>\n",
       "      <td>18.617</td>\n",
       "      <td>109001.30</td>\n",
       "      <td>103741.22</td>\n",
       "      <td>106218.95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-08-31</th>\n",
       "      <td>16.13</td>\n",
       "      <td>16.20</td>\n",
       "      <td>14.95</td>\n",
       "      <td>14.95</td>\n",
       "      <td>79841.72</td>\n",
       "      <td>-1.51</td>\n",
       "      <td>-9.17</td>\n",
       "      <td>15.846</td>\n",
       "      <td>18.104</td>\n",
       "      <td>18.812</td>\n",
       "      <td>98482.73</td>\n",
       "      <td>106864.05</td>\n",
       "      <td>106984.29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-08-28</th>\n",
       "      <td>15.40</td>\n",
       "      <td>16.46</td>\n",
       "      <td>16.46</td>\n",
       "      <td>15.00</td>\n",
       "      <td>117827.60</td>\n",
       "      <td>1.50</td>\n",
       "      <td>10.03</td>\n",
       "      <td>16.698</td>\n",
       "      <td>18.849</td>\n",
       "      <td>18.853</td>\n",
       "      <td>92680.85</td>\n",
       "      <td>109609.73</td>\n",
       "      <td>107384.89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-08-27</th>\n",
       "      <td>15.50</td>\n",
       "      <td>16.50</td>\n",
       "      <td>14.97</td>\n",
       "      <td>14.00</td>\n",
       "      <td>138033.02</td>\n",
       "      <td>-0.59</td>\n",
       "      <td>-3.79</td>\n",
       "      <td>17.478</td>\n",
       "      <td>19.398</td>\n",
       "      <td>18.905</td>\n",
       "      <td>96754.80</td>\n",
       "      <td>113704.39</td>\n",
       "      <td>105345.29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-08-26</th>\n",
       "      <td>17.00</td>\n",
       "      <td>18.35</td>\n",
       "      <td>15.56</td>\n",
       "      <td>15.56</td>\n",
       "      <td>130318.31</td>\n",
       "      <td>-1.73</td>\n",
       "      <td>-10.01</td>\n",
       "      <td>18.742</td>\n",
       "      <td>20.042</td>\n",
       "      <td>19.087</td>\n",
       "      <td>100097.45</td>\n",
       "      <td>114432.06</td>\n",
       "      <td>102945.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-08-25</th>\n",
       "      <td>17.29</td>\n",
       "      <td>17.29</td>\n",
       "      <td>17.29</td>\n",
       "      <td>17.29</td>\n",
       "      <td>26393.00</td>\n",
       "      <td>-1.92</td>\n",
       "      <td>-9.99</td>\n",
       "      <td>19.788</td>\n",
       "      <td>20.486</td>\n",
       "      <td>19.281</td>\n",
       "      <td>98481.13</td>\n",
       "      <td>113477.25</td>\n",
       "      <td>100760.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-08-24</th>\n",
       "      <td>20.00</td>\n",
       "      <td>20.40</td>\n",
       "      <td>19.21</td>\n",
       "      <td>19.21</td>\n",
       "      <td>50832.30</td>\n",
       "      <td>-2.13</td>\n",
       "      <td>-9.98</td>\n",
       "      <td>20.362</td>\n",
       "      <td>20.727</td>\n",
       "      <td>19.349</td>\n",
       "      <td>115245.36</td>\n",
       "      <td>122841.42</td>\n",
       "      <td>105103.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-08-21</th>\n",
       "      <td>20.62</td>\n",
       "      <td>21.90</td>\n",
       "      <td>20.36</td>\n",
       "      <td>19.18</td>\n",
       "      <td>138197.38</td>\n",
       "      <td>-0.89</td>\n",
       "      <td>-4.19</td>\n",
       "      <td>21.000</td>\n",
       "      <td>20.760</td>\n",
       "      <td>19.423</td>\n",
       "      <td>126538.60</td>\n",
       "      <td>127047.87</td>\n",
       "      <td>107525.57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-08-20</th>\n",
       "      <td>20.98</td>\n",
       "      <td>22.67</td>\n",
       "      <td>21.29</td>\n",
       "      <td>20.30</td>\n",
       "      <td>154746.27</td>\n",
       "      <td>0.68</td>\n",
       "      <td>3.30</td>\n",
       "      <td>21.318</td>\n",
       "      <td>20.522</td>\n",
       "      <td>19.374</td>\n",
       "      <td>130653.97</td>\n",
       "      <td>120010.51</td>\n",
       "      <td>105911.26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-08-19</th>\n",
       "      <td>19.00</td>\n",
       "      <td>21.00</td>\n",
       "      <td>20.79</td>\n",
       "      <td>18.14</td>\n",
       "      <td>122236.72</td>\n",
       "      <td>0.63</td>\n",
       "      <td>3.12</td>\n",
       "      <td>21.342</td>\n",
       "      <td>20.128</td>\n",
       "      <td>19.267</td>\n",
       "      <td>128766.66</td>\n",
       "      <td>110596.78</td>\n",
       "      <td>103198.21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-08-18</th>\n",
       "      <td>22.40</td>\n",
       "      <td>22.40</td>\n",
       "      <td>20.16</td>\n",
       "      <td>20.16</td>\n",
       "      <td>110214.14</td>\n",
       "      <td>-2.24</td>\n",
       "      <td>-10.00</td>\n",
       "      <td>21.184</td>\n",
       "      <td>19.800</td>\n",
       "      <td>19.178</td>\n",
       "      <td>128473.37</td>\n",
       "      <td>108696.69</td>\n",
       "      <td>102078.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-08-17</th>\n",
       "      <td>21.67</td>\n",
       "      <td>22.49</td>\n",
       "      <td>22.40</td>\n",
       "      <td>21.43</td>\n",
       "      <td>107298.51</td>\n",
       "      <td>0.46</td>\n",
       "      <td>2.10</td>\n",
       "      <td>21.092</td>\n",
       "      <td>19.519</td>\n",
       "      <td>19.116</td>\n",
       "      <td>130437.47</td>\n",
       "      <td>107104.54</td>\n",
       "      <td>101569.81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-08-14</th>\n",
       "      <td>21.61</td>\n",
       "      <td>22.83</td>\n",
       "      <td>21.95</td>\n",
       "      <td>21.61</td>\n",
       "      <td>158774.20</td>\n",
       "      <td>0.57</td>\n",
       "      <td>2.67</td>\n",
       "      <td>20.520</td>\n",
       "      <td>18.856</td>\n",
       "      <td>18.897</td>\n",
       "      <td>127557.13</td>\n",
       "      <td>105160.06</td>\n",
       "      <td>101187.89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-08-13</th>\n",
       "      <td>20.23</td>\n",
       "      <td>21.54</td>\n",
       "      <td>21.41</td>\n",
       "      <td>20.01</td>\n",
       "      <td>145309.73</td>\n",
       "      <td>1.41</td>\n",
       "      <td>7.05</td>\n",
       "      <td>19.726</td>\n",
       "      <td>18.412</td>\n",
       "      <td>18.679</td>\n",
       "      <td>109367.04</td>\n",
       "      <td>96986.20</td>\n",
       "      <td>97074.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-08-12</th>\n",
       "      <td>19.35</td>\n",
       "      <td>20.64</td>\n",
       "      <td>20.00</td>\n",
       "      <td>19.10</td>\n",
       "      <td>120770.27</td>\n",
       "      <td>0.31</td>\n",
       "      <td>1.57</td>\n",
       "      <td>18.914</td>\n",
       "      <td>18.131</td>\n",
       "      <td>18.469</td>\n",
       "      <td>92426.90</td>\n",
       "      <td>91459.75</td>\n",
       "      <td>93364.19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-08-11</th>\n",
       "      <td>19.60</td>\n",
       "      <td>20.12</td>\n",
       "      <td>19.70</td>\n",
       "      <td>19.00</td>\n",
       "      <td>120034.65</td>\n",
       "      <td>0.15</td>\n",
       "      <td>0.77</td>\n",
       "      <td>18.416</td>\n",
       "      <td>18.076</td>\n",
       "      <td>18.342</td>\n",
       "      <td>88920.00</td>\n",
       "      <td>88044.54</td>\n",
       "      <td>91080.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-08-10</th>\n",
       "      <td>18.22</td>\n",
       "      <td>19.65</td>\n",
       "      <td>19.54</td>\n",
       "      <td>18.22</td>\n",
       "      <td>92896.78</td>\n",
       "      <td>1.57</td>\n",
       "      <td>8.74</td>\n",
       "      <td>17.946</td>\n",
       "      <td>17.971</td>\n",
       "      <td>18.218</td>\n",
       "      <td>83771.60</td>\n",
       "      <td>87365.31</td>\n",
       "      <td>88448.14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-08-07</th>\n",
       "      <td>17.47</td>\n",
       "      <td>17.99</td>\n",
       "      <td>17.98</td>\n",
       "      <td>17.47</td>\n",
       "      <td>67823.78</td>\n",
       "      <td>0.61</td>\n",
       "      <td>3.51</td>\n",
       "      <td>17.192</td>\n",
       "      <td>18.086</td>\n",
       "      <td>18.086</td>\n",
       "      <td>82762.98</td>\n",
       "      <td>88003.27</td>\n",
       "      <td>88003.27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-08-06</th>\n",
       "      <td>16.94</td>\n",
       "      <td>17.98</td>\n",
       "      <td>17.35</td>\n",
       "      <td>16.81</td>\n",
       "      <td>60609.00</td>\n",
       "      <td>-0.15</td>\n",
       "      <td>-0.86</td>\n",
       "      <td>17.098</td>\n",
       "      <td>18.098</td>\n",
       "      <td>18.098</td>\n",
       "      <td>84605.36</td>\n",
       "      <td>90245.44</td>\n",
       "      <td>90245.44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-08-05</th>\n",
       "      <td>17.40</td>\n",
       "      <td>18.36</td>\n",
       "      <td>17.51</td>\n",
       "      <td>17.10</td>\n",
       "      <td>103235.81</td>\n",
       "      <td>0.16</td>\n",
       "      <td>0.92</td>\n",
       "      <td>17.348</td>\n",
       "      <td>18.191</td>\n",
       "      <td>18.191</td>\n",
       "      <td>90492.60</td>\n",
       "      <td>93950.00</td>\n",
       "      <td>93950.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-08-04</th>\n",
       "      <td>16.20</td>\n",
       "      <td>17.35</td>\n",
       "      <td>17.35</td>\n",
       "      <td>15.80</td>\n",
       "      <td>94292.63</td>\n",
       "      <td>1.58</td>\n",
       "      <td>10.02</td>\n",
       "      <td>17.736</td>\n",
       "      <td>18.289</td>\n",
       "      <td>18.289</td>\n",
       "      <td>87169.08</td>\n",
       "      <td>92623.45</td>\n",
       "      <td>92623.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-08-03</th>\n",
       "      <td>17.39</td>\n",
       "      <td>17.39</td>\n",
       "      <td>15.77</td>\n",
       "      <td>15.77</td>\n",
       "      <td>87853.70</td>\n",
       "      <td>-1.75</td>\n",
       "      <td>-9.99</td>\n",
       "      <td>17.996</td>\n",
       "      <td>18.445</td>\n",
       "      <td>18.445</td>\n",
       "      <td>90959.02</td>\n",
       "      <td>92345.25</td>\n",
       "      <td>92345.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-07-31</th>\n",
       "      <td>17.71</td>\n",
       "      <td>18.40</td>\n",
       "      <td>17.51</td>\n",
       "      <td>17.02</td>\n",
       "      <td>77035.64</td>\n",
       "      <td>-1.07</td>\n",
       "      <td>-5.76</td>\n",
       "      <td>18.980</td>\n",
       "      <td>18.980</td>\n",
       "      <td>18.980</td>\n",
       "      <td>93243.56</td>\n",
       "      <td>93243.56</td>\n",
       "      <td>93243.56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-07-30</th>\n",
       "      <td>19.44</td>\n",
       "      <td>19.74</td>\n",
       "      <td>18.60</td>\n",
       "      <td>18.41</td>\n",
       "      <td>90045.23</td>\n",
       "      <td>-0.85</td>\n",
       "      <td>-4.37</td>\n",
       "      <td>19.348</td>\n",
       "      <td>19.348</td>\n",
       "      <td>19.348</td>\n",
       "      <td>97295.55</td>\n",
       "      <td>97295.55</td>\n",
       "      <td>97295.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-07-29</th>\n",
       "      <td>19.12</td>\n",
       "      <td>19.50</td>\n",
       "      <td>19.45</td>\n",
       "      <td>17.20</td>\n",
       "      <td>86618.22</td>\n",
       "      <td>0.82</td>\n",
       "      <td>4.40</td>\n",
       "      <td>19.597</td>\n",
       "      <td>19.597</td>\n",
       "      <td>19.597</td>\n",
       "      <td>99712.32</td>\n",
       "      <td>99712.32</td>\n",
       "      <td>99712.32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-07-28</th>\n",
       "      <td>18.76</td>\n",
       "      <td>20.20</td>\n",
       "      <td>18.65</td>\n",
       "      <td>18.62</td>\n",
       "      <td>113242.29</td>\n",
       "      <td>-2.04</td>\n",
       "      <td>-9.86</td>\n",
       "      <td>19.670</td>\n",
       "      <td>19.670</td>\n",
       "      <td>19.670</td>\n",
       "      <td>106259.37</td>\n",
       "      <td>106259.37</td>\n",
       "      <td>106259.37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-07-27</th>\n",
       "      <td>22.30</td>\n",
       "      <td>23.65</td>\n",
       "      <td>20.69</td>\n",
       "      <td>20.69</td>\n",
       "      <td>99276.44</td>\n",
       "      <td>-2.30</td>\n",
       "      <td>-10.00</td>\n",
       "      <td>20.690</td>\n",
       "      <td>20.690</td>\n",
       "      <td>20.690</td>\n",
       "      <td>99276.44</td>\n",
       "      <td>99276.44</td>\n",
       "      <td>99276.44</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>620 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             open   high  close    low     volume  price_change  p_change  \\\n",
       "date                                                                        \n",
       "2018-06-14  21.76  21.94  21.68  21.56   15457.00         -0.07     -0.32   \n",
       "2018-06-13  22.00  22.14  21.76  21.74   15149.00         -0.32     -1.45   \n",
       "2018-06-12  21.94  22.15  22.08  21.77   16061.00          0.14      0.64   \n",
       "2018-06-11  22.01  22.16  21.95  21.81   15324.49         -0.06     -0.27   \n",
       "2018-06-08  22.16  22.16  22.00  21.81   23499.00         -0.32     -1.43   \n",
       "2018-06-07  22.88  22.88  22.33  22.23   32495.78         -0.29     -1.28   \n",
       "2018-06-06  23.10  23.23  22.68  22.48   63223.83          0.65      2.95   \n",
       "2018-06-05  21.73  22.05  22.03  21.69   19257.19          0.30      1.38   \n",
       "2018-06-04  21.82  22.07  21.73  21.53   18135.00          0.00      0.00   \n",
       "2018-06-01  22.12  22.12  21.73  21.61   25226.00         -0.33     -1.50   \n",
       "2018-05-31  21.88  22.25  22.08  21.80   29562.00          0.40      1.84   \n",
       "2018-05-30  22.48  22.68  21.69  21.66   59913.80         -1.22     -5.33   \n",
       "2018-05-29  23.04  23.24  22.92  22.82   32026.12         -0.17     -0.74   \n",
       "2018-05-28  23.32  23.63  23.10  23.01   61616.24         -0.65     -2.74   \n",
       "2018-05-25  24.21  25.00  23.77  23.72  115681.51          0.48      2.06   \n",
       "2018-05-24  23.46  23.55  23.28  23.26   21509.00         -0.07     -0.30   \n",
       "2018-05-23  23.63  23.70  23.34  23.32   26356.83         -0.35     -1.48   \n",
       "2018-05-22  23.82  24.09  23.82  23.55   32100.10         -0.11     -0.46   \n",
       "2018-05-21  23.99  24.19  23.95  23.71   43266.00          0.15      0.63   \n",
       "2018-05-18  23.50  23.90  23.79  23.21   38775.43          0.08      0.34   \n",
       "2018-05-17  24.01  24.30  23.71  23.69   46761.13         -0.51     -2.11   \n",
       "2018-05-16  24.50  24.52  24.21  24.03   63134.55         -0.51     -2.06   \n",
       "2018-05-15  25.49  25.60  24.72  24.49  147773.38          0.00      0.00   \n",
       "2018-05-14  23.59  24.95  24.71  23.50  101656.17          1.09      4.62   \n",
       "2018-05-11  23.91  23.91  23.61  23.44   23204.80         -0.16     -0.67   \n",
       "2018-05-10  23.70  23.92  23.76  23.65   29694.83          0.04      0.17   \n",
       "2018-05-09  23.72  23.92  23.72  23.67   34419.00         -0.22     -0.92   \n",
       "2018-05-08  23.60  23.95  23.95  23.39   54032.76          0.38      1.61   \n",
       "2018-05-07  23.50  23.65  23.56  23.10   42973.67          0.07      0.30   \n",
       "2018-05-04  23.75  23.96  23.46  23.42   33101.83         -0.27     -1.14   \n",
       "...           ...    ...    ...    ...        ...           ...       ...   \n",
       "2015-09-08  12.89  13.98  13.85  12.67   60627.79          1.09      8.54   \n",
       "2015-09-07  12.92  13.38  12.77  12.63   52490.04          0.37      2.98   \n",
       "2015-09-02  12.30  14.11  12.36  12.30   70201.74         -1.10     -8.17   \n",
       "2015-09-01  14.78  14.78  13.46  13.46   78985.85         -1.50    -10.03   \n",
       "2015-08-31  16.13  16.20  14.95  14.95   79841.72         -1.51     -9.17   \n",
       "2015-08-28  15.40  16.46  16.46  15.00  117827.60          1.50     10.03   \n",
       "2015-08-27  15.50  16.50  14.97  14.00  138033.02         -0.59     -3.79   \n",
       "2015-08-26  17.00  18.35  15.56  15.56  130318.31         -1.73    -10.01   \n",
       "2015-08-25  17.29  17.29  17.29  17.29   26393.00         -1.92     -9.99   \n",
       "2015-08-24  20.00  20.40  19.21  19.21   50832.30         -2.13     -9.98   \n",
       "2015-08-21  20.62  21.90  20.36  19.18  138197.38         -0.89     -4.19   \n",
       "2015-08-20  20.98  22.67  21.29  20.30  154746.27          0.68      3.30   \n",
       "2015-08-19  19.00  21.00  20.79  18.14  122236.72          0.63      3.12   \n",
       "2015-08-18  22.40  22.40  20.16  20.16  110214.14         -2.24    -10.00   \n",
       "2015-08-17  21.67  22.49  22.40  21.43  107298.51          0.46      2.10   \n",
       "2015-08-14  21.61  22.83  21.95  21.61  158774.20          0.57      2.67   \n",
       "2015-08-13  20.23  21.54  21.41  20.01  145309.73          1.41      7.05   \n",
       "2015-08-12  19.35  20.64  20.00  19.10  120770.27          0.31      1.57   \n",
       "2015-08-11  19.60  20.12  19.70  19.00  120034.65          0.15      0.77   \n",
       "2015-08-10  18.22  19.65  19.54  18.22   92896.78          1.57      8.74   \n",
       "2015-08-07  17.47  17.99  17.98  17.47   67823.78          0.61      3.51   \n",
       "2015-08-06  16.94  17.98  17.35  16.81   60609.00         -0.15     -0.86   \n",
       "2015-08-05  17.40  18.36  17.51  17.10  103235.81          0.16      0.92   \n",
       "2015-08-04  16.20  17.35  17.35  15.80   94292.63          1.58     10.02   \n",
       "2015-08-03  17.39  17.39  15.77  15.77   87853.70         -1.75     -9.99   \n",
       "2015-07-31  17.71  18.40  17.51  17.02   77035.64         -1.07     -5.76   \n",
       "2015-07-30  19.44  19.74  18.60  18.41   90045.23         -0.85     -4.37   \n",
       "2015-07-29  19.12  19.50  19.45  17.20   86618.22          0.82      4.40   \n",
       "2015-07-28  18.76  20.20  18.65  18.62  113242.29         -2.04     -9.86   \n",
       "2015-07-27  22.30  23.65  20.69  20.69   99276.44         -2.30    -10.00   \n",
       "\n",
       "               ma5    ma10    ma20      v_ma5     v_ma10     v_ma20  \n",
       "date                                                                 \n",
       "2018-06-14  21.894  21.997  22.586   17098.10   24382.83   35231.77  \n",
       "2018-06-13  22.024  22.037  22.687   20505.85   25793.33   36796.97  \n",
       "2018-06-12  22.208  22.030  22.810   30120.82   30269.81   39196.25  \n",
       "2018-06-11  22.198  22.114  22.942   30760.06   31866.32   45781.87  \n",
       "2018-06-08  22.154  22.229  23.080   31322.16   36495.50   50098.45  \n",
       "2018-06-07  22.100  22.406  23.160   31667.56   45713.75   50083.74  \n",
       "2018-06-06  22.050  22.501  23.232   31080.80   44615.07   49943.70  \n",
       "2018-06-05  21.852  22.567  23.284   30418.80   40928.37   48503.45  \n",
       "2018-06-04  22.030  22.746  23.380   32972.58   42212.66   50242.23  \n",
       "2018-06-01  22.304  22.968  23.471   41668.83   44725.76   51484.17  \n",
       "2018-05-31  22.712  23.174  23.558   59759.93   46080.70   51877.96  \n",
       "2018-05-30  22.952  23.337  23.640   58149.33   47800.62   52569.85  \n",
       "2018-05-29  23.282  23.589  23.710   51437.94   48122.69   51903.48  \n",
       "2018-05-28  23.462  23.769  23.763   51452.74   59697.42   52007.91  \n",
       "2018-05-25  23.632  23.930  23.792   47782.69   63701.41   50834.62  \n",
       "2018-05-24  23.636  23.914  23.800   32401.47   54453.74   47065.36  \n",
       "2018-05-23  23.722  23.962  23.825   37451.90   55272.32   48358.47  \n",
       "2018-05-22  23.896  24.000  23.818   44807.44   56078.54   49073.87  \n",
       "2018-05-21  24.076  24.013  23.792   67942.10   58271.81   50561.21  \n",
       "2018-05-18  24.228  23.974  23.809   79620.13   58242.57   50828.43  \n",
       "2018-05-17  24.192  23.941  23.828   76506.01   57675.21   52611.47  \n",
       "2018-05-16  24.202  23.943  23.860   73092.75   57339.08   53277.90  \n",
       "2018-05-15  24.104  23.830  23.890   67349.64   55684.26   55653.07  \n",
       "2018-05-14  23.950  23.757  23.949   48601.51   44318.40   52074.44  \n",
       "2018-05-11  23.720  23.654  24.007   36865.01   37967.84   51474.99  \n",
       "2018-05-10  23.690  23.685  24.162   38844.42   39676.99   60099.05  \n",
       "2018-05-09  23.684  23.688  24.284   41585.42   41444.61   69127.78  \n",
       "2018-05-08  23.556  23.635  24.455   44018.89   42069.20   76832.94  \n",
       "2018-05-07  23.564  23.570  24.564   40035.29   42850.62   80910.98  \n",
       "2018-05-04  23.588  23.644  24.678   39070.66   43414.29   87868.78  \n",
       "...            ...     ...     ...        ...        ...        ...  \n",
       "2015-09-08  13.478  15.088  17.924   68429.43   80555.14  103801.50  \n",
       "2015-09-07  14.000  15.739  18.131   79869.39   88312.10  104161.30  \n",
       "2015-09-02  14.440  16.591  18.360   96977.99   98537.72  104567.25  \n",
       "2015-09-01  15.080  17.434  18.617  109001.30  103741.22  106218.95  \n",
       "2015-08-31  15.846  18.104  18.812   98482.73  106864.05  106984.29  \n",
       "2015-08-28  16.698  18.849  18.853   92680.85  109609.73  107384.89  \n",
       "2015-08-27  17.478  19.398  18.905   96754.80  113704.39  105345.29  \n",
       "2015-08-26  18.742  20.042  19.087  100097.45  114432.06  102945.90  \n",
       "2015-08-25  19.788  20.486  19.281   98481.13  113477.25  100760.90  \n",
       "2015-08-24  20.362  20.727  19.349  115245.36  122841.42  105103.36  \n",
       "2015-08-21  21.000  20.760  19.423  126538.60  127047.87  107525.57  \n",
       "2015-08-20  21.318  20.522  19.374  130653.97  120010.51  105911.26  \n",
       "2015-08-19  21.342  20.128  19.267  128766.66  110596.78  103198.21  \n",
       "2015-08-18  21.184  19.800  19.178  128473.37  108696.69  102078.30  \n",
       "2015-08-17  21.092  19.519  19.116  130437.47  107104.54  101569.81  \n",
       "2015-08-14  20.520  18.856  18.897  127557.13  105160.06  101187.89  \n",
       "2015-08-13  19.726  18.412  18.679  109367.04   96986.20   97074.58  \n",
       "2015-08-12  18.914  18.131  18.469   92426.90   91459.75   93364.19  \n",
       "2015-08-11  18.416  18.076  18.342   88920.00   88044.54   91080.35  \n",
       "2015-08-10  17.946  17.971  18.218   83771.60   87365.31   88448.14  \n",
       "2015-08-07  17.192  18.086  18.086   82762.98   88003.27   88003.27  \n",
       "2015-08-06  17.098  18.098  18.098   84605.36   90245.44   90245.44  \n",
       "2015-08-05  17.348  18.191  18.191   90492.60   93950.00   93950.00  \n",
       "2015-08-04  17.736  18.289  18.289   87169.08   92623.45   92623.45  \n",
       "2015-08-03  17.996  18.445  18.445   90959.02   92345.25   92345.25  \n",
       "2015-07-31  18.980  18.980  18.980   93243.56   93243.56   93243.56  \n",
       "2015-07-30  19.348  19.348  19.348   97295.55   97295.55   97295.55  \n",
       "2015-07-29  19.597  19.597  19.597   99712.32   99712.32   99712.32  \n",
       "2015-07-28  19.670  19.670  19.670  106259.37  106259.37  106259.37  \n",
       "2015-07-27  20.690  20.690  20.690   99276.44   99276.44   99276.44  \n",
       "\n",
       "[620 rows x 13 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ts.get_hist_data('300036') #一次性获取全部日k线数据"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "ts.get_hist_data('300036',start='2018-07-01',end='2018-07-30') #一次性获取全部日k线数据"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "df2 = ts.get_hist_data('300036',start='2018-07-01',end='2018-07-30') #命名文件\n",
    "df2.to_csv(\"300036july.csv\")#保存文件"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "df3 = ts.get_money_supply()#货币供应量"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "df3.to_csv(\"moneysupply.csv\")#保存文件"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>month</th>\n",
       "      <th>m2</th>\n",
       "      <th>m2_yoy</th>\n",
       "      <th>m1</th>\n",
       "      <th>m1_yoy</th>\n",
       "      <th>m0</th>\n",
       "      <th>m0_yoy</th>\n",
       "      <th>cd</th>\n",
       "      <th>cd_yoy</th>\n",
       "      <th>qm</th>\n",
       "      <th>qm_yoy</th>\n",
       "      <th>ftd</th>\n",
       "      <th>ftd_yoy</th>\n",
       "      <th>sd</th>\n",
       "      <th>sd_yoy</th>\n",
       "      <th>rests</th>\n",
       "      <th>rests_yoy</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2018.6</td>\n",
       "      <td>1770178.37</td>\n",
       "      <td>8.30</td>\n",
       "      <td>543944.71</td>\n",
       "      <td>6.00</td>\n",
       "      <td>69589.33</td>\n",
       "      <td>3.60</td>\n",
       "      <td>474355.38</td>\n",
       "      <td>--</td>\n",
       "      <td>1226233.66</td>\n",
       "      <td>--</td>\n",
       "      <td>334425.29</td>\n",
       "      <td>--</td>\n",
       "      <td>692440.77</td>\n",
       "      <td>--</td>\n",
       "      <td>199367.60</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2018.5</td>\n",
       "      <td>1743063.79</td>\n",
       "      <td>8.30</td>\n",
       "      <td>526276.72</td>\n",
       "      <td>6.00</td>\n",
       "      <td>69774.81</td>\n",
       "      <td>3.60</td>\n",
       "      <td>456501.91</td>\n",
       "      <td>--</td>\n",
       "      <td>1216787.08</td>\n",
       "      <td>--</td>\n",
       "      <td>336063.23</td>\n",
       "      <td>--</td>\n",
       "      <td>681333.90</td>\n",
       "      <td>--</td>\n",
       "      <td>199389.95</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2018.4</td>\n",
       "      <td>1737683.73</td>\n",
       "      <td>8.30</td>\n",
       "      <td>525447.77</td>\n",
       "      <td>7.20</td>\n",
       "      <td>71476.46</td>\n",
       "      <td>4.50</td>\n",
       "      <td>453971.31</td>\n",
       "      <td>--</td>\n",
       "      <td>1212235.96</td>\n",
       "      <td>--</td>\n",
       "      <td>335348.35</td>\n",
       "      <td>--</td>\n",
       "      <td>679185.94</td>\n",
       "      <td>--</td>\n",
       "      <td>197701.67</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2018.3</td>\n",
       "      <td>1739859.48</td>\n",
       "      <td>8.20</td>\n",
       "      <td>523540.07</td>\n",
       "      <td>7.10</td>\n",
       "      <td>72692.63</td>\n",
       "      <td>6.00</td>\n",
       "      <td>450847.45</td>\n",
       "      <td>--</td>\n",
       "      <td>1216319.40</td>\n",
       "      <td>--</td>\n",
       "      <td>332605.89</td>\n",
       "      <td>--</td>\n",
       "      <td>692563.69</td>\n",
       "      <td>--</td>\n",
       "      <td>191149.82</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2018.2</td>\n",
       "      <td>1729070.12</td>\n",
       "      <td>8.80</td>\n",
       "      <td>517035.99</td>\n",
       "      <td>8.50</td>\n",
       "      <td>81424.24</td>\n",
       "      <td>13.50</td>\n",
       "      <td>435611.75</td>\n",
       "      <td>--</td>\n",
       "      <td>1212034.13</td>\n",
       "      <td>--</td>\n",
       "      <td>330531.73</td>\n",
       "      <td>--</td>\n",
       "      <td>687076.39</td>\n",
       "      <td>--</td>\n",
       "      <td>194426.00</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2018.1</td>\n",
       "      <td>1720814.46</td>\n",
       "      <td>8.62</td>\n",
       "      <td>543247.13</td>\n",
       "      <td>14.97</td>\n",
       "      <td>74636.29</td>\n",
       "      <td>-13.81</td>\n",
       "      <td>468610.84</td>\n",
       "      <td>--</td>\n",
       "      <td>1177567.33</td>\n",
       "      <td>--</td>\n",
       "      <td>328169.80</td>\n",
       "      <td>--</td>\n",
       "      <td>658424.25</td>\n",
       "      <td>--</td>\n",
       "      <td>190973.27</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2017.12</td>\n",
       "      <td>1676768.54</td>\n",
       "      <td>8.10</td>\n",
       "      <td>543790.15</td>\n",
       "      <td>11.80</td>\n",
       "      <td>70645.60</td>\n",
       "      <td>3.40</td>\n",
       "      <td>473144.55</td>\n",
       "      <td>--</td>\n",
       "      <td>1132978.39</td>\n",
       "      <td>--</td>\n",
       "      <td>320196.23</td>\n",
       "      <td>--</td>\n",
       "      <td>649341.50</td>\n",
       "      <td>--</td>\n",
       "      <td>163440.66</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2017.11</td>\n",
       "      <td>1670013.40</td>\n",
       "      <td>9.10</td>\n",
       "      <td>535565.05</td>\n",
       "      <td>12.70</td>\n",
       "      <td>68623.16</td>\n",
       "      <td>5.70</td>\n",
       "      <td>466941.89</td>\n",
       "      <td>--</td>\n",
       "      <td>1134448.35</td>\n",
       "      <td>--</td>\n",
       "      <td>320651.87</td>\n",
       "      <td>--</td>\n",
       "      <td>641619.60</td>\n",
       "      <td>--</td>\n",
       "      <td>172176.88</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2017.10</td>\n",
       "      <td>1653434.16</td>\n",
       "      <td>8.90</td>\n",
       "      <td>525977.19</td>\n",
       "      <td>13.00</td>\n",
       "      <td>68230.69</td>\n",
       "      <td>6.30</td>\n",
       "      <td>457746.50</td>\n",
       "      <td>--</td>\n",
       "      <td>1127456.97</td>\n",
       "      <td>--</td>\n",
       "      <td>319740.97</td>\n",
       "      <td>--</td>\n",
       "      <td>640250.93</td>\n",
       "      <td>--</td>\n",
       "      <td>167465.07</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2017.9</td>\n",
       "      <td>1655662.07</td>\n",
       "      <td>9.00</td>\n",
       "      <td>517863.04</td>\n",
       "      <td>14.00</td>\n",
       "      <td>69748.54</td>\n",
       "      <td>7.20</td>\n",
       "      <td>448114.50</td>\n",
       "      <td>--</td>\n",
       "      <td>1137799.03</td>\n",
       "      <td>--</td>\n",
       "      <td>326614.31</td>\n",
       "      <td>--</td>\n",
       "      <td>648349.70</td>\n",
       "      <td>--</td>\n",
       "      <td>162835.01</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     month          m2 m2_yoy         m1 m1_yoy        m0  m0_yoy         cd  \\\n",
       "0   2018.6  1770178.37   8.30  543944.71   6.00  69589.33    3.60  474355.38   \n",
       "1   2018.5  1743063.79   8.30  526276.72   6.00  69774.81    3.60  456501.91   \n",
       "2   2018.4  1737683.73   8.30  525447.77   7.20  71476.46    4.50  453971.31   \n",
       "3   2018.3  1739859.48   8.20  523540.07   7.10  72692.63    6.00  450847.45   \n",
       "4   2018.2  1729070.12   8.80  517035.99   8.50  81424.24   13.50  435611.75   \n",
       "5   2018.1  1720814.46   8.62  543247.13  14.97  74636.29  -13.81  468610.84   \n",
       "6  2017.12  1676768.54   8.10  543790.15  11.80  70645.60    3.40  473144.55   \n",
       "7  2017.11  1670013.40   9.10  535565.05  12.70  68623.16    5.70  466941.89   \n",
       "8  2017.10  1653434.16   8.90  525977.19  13.00  68230.69    6.30  457746.50   \n",
       "9   2017.9  1655662.07   9.00  517863.04  14.00  69748.54    7.20  448114.50   \n",
       "\n",
       "  cd_yoy          qm qm_yoy        ftd ftd_yoy         sd sd_yoy      rests  \\\n",
       "0     --  1226233.66     --  334425.29      --  692440.77     --  199367.60   \n",
       "1     --  1216787.08     --  336063.23      --  681333.90     --  199389.95   \n",
       "2     --  1212235.96     --  335348.35      --  679185.94     --  197701.67   \n",
       "3     --  1216319.40     --  332605.89      --  692563.69     --  191149.82   \n",
       "4     --  1212034.13     --  330531.73      --  687076.39     --  194426.00   \n",
       "5     --  1177567.33     --  328169.80      --  658424.25     --  190973.27   \n",
       "6     --  1132978.39     --  320196.23      --  649341.50     --  163440.66   \n",
       "7     --  1134448.35     --  320651.87      --  641619.60     --  172176.88   \n",
       "8     --  1127456.97     --  319740.97      --  640250.93     --  167465.07   \n",
       "9     --  1137799.03     --  326614.31      --  648349.70     --  162835.01   \n",
       "\n",
       "  rests_yoy  \n",
       "0        --  \n",
       "1        --  \n",
       "2        --  \n",
       "3        --  \n",
       "4        --  \n",
       "5        --  \n",
       "6        --  \n",
       "7        --  \n",
       "8        --  \n",
       "9        --  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df3.head(10)#前10行数据"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>month</th>\n",
       "      <th>m2</th>\n",
       "      <th>m2_yoy</th>\n",
       "      <th>m1</th>\n",
       "      <th>m1_yoy</th>\n",
       "      <th>m0</th>\n",
       "      <th>m0_yoy</th>\n",
       "      <th>cd</th>\n",
       "      <th>cd_yoy</th>\n",
       "      <th>qm</th>\n",
       "      <th>qm_yoy</th>\n",
       "      <th>ftd</th>\n",
       "      <th>ftd_yoy</th>\n",
       "      <th>sd</th>\n",
       "      <th>sd_yoy</th>\n",
       "      <th>rests</th>\n",
       "      <th>rests_yoy</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>476</th>\n",
       "      <td>1978.10</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>778.64</td>\n",
       "      <td>--</td>\n",
       "      <td>185.24</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>477</th>\n",
       "      <td>1978.9</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>763.47</td>\n",
       "      <td>--</td>\n",
       "      <td>188.27</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>478</th>\n",
       "      <td>1978.8</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>755.99</td>\n",
       "      <td>--</td>\n",
       "      <td>182.12</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>479</th>\n",
       "      <td>1978.7</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>746.43</td>\n",
       "      <td>--</td>\n",
       "      <td>181.02</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>480</th>\n",
       "      <td>1978.6</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>745.08</td>\n",
       "      <td>--</td>\n",
       "      <td>178.46</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>481</th>\n",
       "      <td>1978.5</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>757.93</td>\n",
       "      <td>--</td>\n",
       "      <td>182.17</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>482</th>\n",
       "      <td>1978.4</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>808.17</td>\n",
       "      <td>--</td>\n",
       "      <td>192.63</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>483</th>\n",
       "      <td>1978.3</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>827.83</td>\n",
       "      <td>--</td>\n",
       "      <td>194.86</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>484</th>\n",
       "      <td>1978.2</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>833.35</td>\n",
       "      <td>--</td>\n",
       "      <td>205.89</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>485</th>\n",
       "      <td>1978.1</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>870.53</td>\n",
       "      <td>--</td>\n",
       "      <td>229.59</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       month  m2 m2_yoy      m1 m1_yoy      m0 m0_yoy  cd cd_yoy  qm qm_yoy  \\\n",
       "476  1978.10  --     --  778.64     --  185.24     --  --     --  --     --   \n",
       "477   1978.9  --     --  763.47     --  188.27     --  --     --  --     --   \n",
       "478   1978.8  --     --  755.99     --  182.12     --  --     --  --     --   \n",
       "479   1978.7  --     --  746.43     --  181.02     --  --     --  --     --   \n",
       "480   1978.6  --     --  745.08     --  178.46     --  --     --  --     --   \n",
       "481   1978.5  --     --  757.93     --  182.17     --  --     --  --     --   \n",
       "482   1978.4  --     --  808.17     --  192.63     --  --     --  --     --   \n",
       "483   1978.3  --     --  827.83     --  194.86     --  --     --  --     --   \n",
       "484   1978.2  --     --  833.35     --  205.89     --  --     --  --     --   \n",
       "485   1978.1  --     --  870.53     --  229.59     --  --     --  --     --   \n",
       "\n",
       "    ftd ftd_yoy  sd sd_yoy rests rests_yoy  \n",
       "476  --      --  --     --    --        --  \n",
       "477  --      --  --     --    --        --  \n",
       "478  --      --  --     --    --        --  \n",
       "479  --      --  --     --    --        --  \n",
       "480  --      --  --     --    --        --  \n",
       "481  --      --  --     --    --        --  \n",
       "482  --      --  --     --    --        --  \n",
       "483  --      --  --     --    --        --  \n",
       "484  --      --  --     --    --        --  \n",
       "485  --      --  --     --    --        --  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df3.tail(10)#最后10行数据"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>month</th>\n",
       "      <th>m2</th>\n",
       "      <th>m2_yoy</th>\n",
       "      <th>m1</th>\n",
       "      <th>m1_yoy</th>\n",
       "      <th>m0</th>\n",
       "      <th>m0_yoy</th>\n",
       "      <th>cd</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2018.6</td>\n",
       "      <td>1770178.37</td>\n",
       "      <td>8.30</td>\n",
       "      <td>543944.71</td>\n",
       "      <td>6.00</td>\n",
       "      <td>69589.33</td>\n",
       "      <td>3.60</td>\n",
       "      <td>474355.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2018.5</td>\n",
       "      <td>1743063.79</td>\n",
       "      <td>8.30</td>\n",
       "      <td>526276.72</td>\n",
       "      <td>6.00</td>\n",
       "      <td>69774.81</td>\n",
       "      <td>3.60</td>\n",
       "      <td>456501.91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2018.4</td>\n",
       "      <td>1737683.73</td>\n",
       "      <td>8.30</td>\n",
       "      <td>525447.77</td>\n",
       "      <td>7.20</td>\n",
       "      <td>71476.46</td>\n",
       "      <td>4.50</td>\n",
       "      <td>453971.31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2018.3</td>\n",
       "      <td>1739859.48</td>\n",
       "      <td>8.20</td>\n",
       "      <td>523540.07</td>\n",
       "      <td>7.10</td>\n",
       "      <td>72692.63</td>\n",
       "      <td>6.00</td>\n",
       "      <td>450847.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2018.2</td>\n",
       "      <td>1729070.12</td>\n",
       "      <td>8.80</td>\n",
       "      <td>517035.99</td>\n",
       "      <td>8.50</td>\n",
       "      <td>81424.24</td>\n",
       "      <td>13.50</td>\n",
       "      <td>435611.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2018.1</td>\n",
       "      <td>1720814.46</td>\n",
       "      <td>8.62</td>\n",
       "      <td>543247.13</td>\n",
       "      <td>14.97</td>\n",
       "      <td>74636.29</td>\n",
       "      <td>-13.81</td>\n",
       "      <td>468610.84</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2017.12</td>\n",
       "      <td>1676768.54</td>\n",
       "      <td>8.10</td>\n",
       "      <td>543790.15</td>\n",
       "      <td>11.80</td>\n",
       "      <td>70645.60</td>\n",
       "      <td>3.40</td>\n",
       "      <td>473144.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2017.11</td>\n",
       "      <td>1670013.40</td>\n",
       "      <td>9.10</td>\n",
       "      <td>535565.05</td>\n",
       "      <td>12.70</td>\n",
       "      <td>68623.16</td>\n",
       "      <td>5.70</td>\n",
       "      <td>466941.89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2017.10</td>\n",
       "      <td>1653434.16</td>\n",
       "      <td>8.90</td>\n",
       "      <td>525977.19</td>\n",
       "      <td>13.00</td>\n",
       "      <td>68230.69</td>\n",
       "      <td>6.30</td>\n",
       "      <td>457746.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2017.9</td>\n",
       "      <td>1655662.07</td>\n",
       "      <td>9.00</td>\n",
       "      <td>517863.04</td>\n",
       "      <td>14.00</td>\n",
       "      <td>69748.54</td>\n",
       "      <td>7.20</td>\n",
       "      <td>448114.50</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     month          m2 m2_yoy         m1 m1_yoy        m0  m0_yoy         cd\n",
       "0   2018.6  1770178.37   8.30  543944.71   6.00  69589.33    3.60  474355.38\n",
       "1   2018.5  1743063.79   8.30  526276.72   6.00  69774.81    3.60  456501.91\n",
       "2   2018.4  1737683.73   8.30  525447.77   7.20  71476.46    4.50  453971.31\n",
       "3   2018.3  1739859.48   8.20  523540.07   7.10  72692.63    6.00  450847.45\n",
       "4   2018.2  1729070.12   8.80  517035.99   8.50  81424.24   13.50  435611.75\n",
       "5   2018.1  1720814.46   8.62  543247.13  14.97  74636.29  -13.81  468610.84\n",
       "6  2017.12  1676768.54   8.10  543790.15  11.80  70645.60    3.40  473144.55\n",
       "7  2017.11  1670013.40   9.10  535565.05  12.70  68623.16    5.70  466941.89\n",
       "8  2017.10  1653434.16   8.90  525977.19  13.00  68230.69    6.30  457746.50\n",
       "9   2017.9  1655662.07   9.00  517863.04  14.00  69748.54    7.20  448114.50"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df3.iloc[0:10,0:8]#( 1-10行，1-8列)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>month</th>\n",
       "      <th>m2</th>\n",
       "      <th>m2_yoy</th>\n",
       "      <th>m1</th>\n",
       "      <th>m1_yoy</th>\n",
       "      <th>m0</th>\n",
       "      <th>m0_yoy</th>\n",
       "      <th>cd</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2018.5</td>\n",
       "      <td>1743063.79</td>\n",
       "      <td>8.30</td>\n",
       "      <td>526276.72</td>\n",
       "      <td>6.00</td>\n",
       "      <td>69774.81</td>\n",
       "      <td>3.60</td>\n",
       "      <td>456501.91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2018.4</td>\n",
       "      <td>1737683.73</td>\n",
       "      <td>8.30</td>\n",
       "      <td>525447.77</td>\n",
       "      <td>7.20</td>\n",
       "      <td>71476.46</td>\n",
       "      <td>4.50</td>\n",
       "      <td>453971.31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2018.3</td>\n",
       "      <td>1739859.48</td>\n",
       "      <td>8.20</td>\n",
       "      <td>523540.07</td>\n",
       "      <td>7.10</td>\n",
       "      <td>72692.63</td>\n",
       "      <td>6.00</td>\n",
       "      <td>450847.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2018.2</td>\n",
       "      <td>1729070.12</td>\n",
       "      <td>8.80</td>\n",
       "      <td>517035.99</td>\n",
       "      <td>8.50</td>\n",
       "      <td>81424.24</td>\n",
       "      <td>13.50</td>\n",
       "      <td>435611.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2018.1</td>\n",
       "      <td>1720814.46</td>\n",
       "      <td>8.62</td>\n",
       "      <td>543247.13</td>\n",
       "      <td>14.97</td>\n",
       "      <td>74636.29</td>\n",
       "      <td>-13.81</td>\n",
       "      <td>468610.84</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2017.12</td>\n",
       "      <td>1676768.54</td>\n",
       "      <td>8.10</td>\n",
       "      <td>543790.15</td>\n",
       "      <td>11.80</td>\n",
       "      <td>70645.60</td>\n",
       "      <td>3.40</td>\n",
       "      <td>473144.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2017.11</td>\n",
       "      <td>1670013.40</td>\n",
       "      <td>9.10</td>\n",
       "      <td>535565.05</td>\n",
       "      <td>12.70</td>\n",
       "      <td>68623.16</td>\n",
       "      <td>5.70</td>\n",
       "      <td>466941.89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2017.10</td>\n",
       "      <td>1653434.16</td>\n",
       "      <td>8.90</td>\n",
       "      <td>525977.19</td>\n",
       "      <td>13.00</td>\n",
       "      <td>68230.69</td>\n",
       "      <td>6.30</td>\n",
       "      <td>457746.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2017.9</td>\n",
       "      <td>1655662.07</td>\n",
       "      <td>9.00</td>\n",
       "      <td>517863.04</td>\n",
       "      <td>14.00</td>\n",
       "      <td>69748.54</td>\n",
       "      <td>7.20</td>\n",
       "      <td>448114.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2017.8</td>\n",
       "      <td>1645156.60</td>\n",
       "      <td>8.60</td>\n",
       "      <td>518113.93</td>\n",
       "      <td>14.00</td>\n",
       "      <td>67550.99</td>\n",
       "      <td>6.50</td>\n",
       "      <td>450562.94</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      month          m2 m2_yoy         m1 m1_yoy        m0  m0_yoy         cd\n",
       "1    2018.5  1743063.79   8.30  526276.72   6.00  69774.81    3.60  456501.91\n",
       "2    2018.4  1737683.73   8.30  525447.77   7.20  71476.46    4.50  453971.31\n",
       "3    2018.3  1739859.48   8.20  523540.07   7.10  72692.63    6.00  450847.45\n",
       "4    2018.2  1729070.12   8.80  517035.99   8.50  81424.24   13.50  435611.75\n",
       "5    2018.1  1720814.46   8.62  543247.13  14.97  74636.29  -13.81  468610.84\n",
       "6   2017.12  1676768.54   8.10  543790.15  11.80  70645.60    3.40  473144.55\n",
       "7   2017.11  1670013.40   9.10  535565.05  12.70  68623.16    5.70  466941.89\n",
       "8   2017.10  1653434.16   8.90  525977.19  13.00  68230.69    6.30  457746.50\n",
       "9    2017.9  1655662.07   9.00  517863.04  14.00  69748.54    7.20  448114.50\n",
       "10   2017.8  1645156.60   8.60  518113.93  14.00  67550.99    6.50  450562.94"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df3.loc[0:10,:\"cd\"]#截取序号0-10，列号开始至cd列)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>month</th>\n",
       "      <th>m2</th>\n",
       "      <th>m2_yoy</th>\n",
       "      <th>m1</th>\n",
       "      <th>m1_yoy</th>\n",
       "      <th>m0</th>\n",
       "      <th>m0_yoy</th>\n",
       "      <th>cd</th>\n",
       "      <th>cd_yoy</th>\n",
       "      <th>qm</th>\n",
       "      <th>qm_yoy</th>\n",
       "      <th>ftd</th>\n",
       "      <th>ftd_yoy</th>\n",
       "      <th>sd</th>\n",
       "      <th>sd_yoy</th>\n",
       "      <th>rests</th>\n",
       "      <th>rests_yoy</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>2010.12</td>\n",
       "      <td>725851.79</td>\n",
       "      <td>19.72</td>\n",
       "      <td>266621.54</td>\n",
       "      <td>21.19</td>\n",
       "      <td>44628.17</td>\n",
       "      <td>16.69</td>\n",
       "      <td>221993.37</td>\n",
       "      <td>22.14</td>\n",
       "      <td>459230.25</td>\n",
       "      <td>18.88</td>\n",
       "      <td>143232.08</td>\n",
       "      <td>28.65</td>\n",
       "      <td>303093.01</td>\n",
       "      <td>16.31</td>\n",
       "      <td>12905.15</td>\n",
       "      <td>15.81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>2010.11</td>\n",
       "      <td>710339.02</td>\n",
       "      <td>19.50</td>\n",
       "      <td>259420.32</td>\n",
       "      <td>22.10</td>\n",
       "      <td>42252.16</td>\n",
       "      <td>16.30</td>\n",
       "      <td>217168.16</td>\n",
       "      <td>--</td>\n",
       "      <td>450918.70</td>\n",
       "      <td>--</td>\n",
       "      <td>140202.84</td>\n",
       "      <td>--</td>\n",
       "      <td>293426.73</td>\n",
       "      <td>--</td>\n",
       "      <td>17289.13</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>2010.10</td>\n",
       "      <td>699776.74</td>\n",
       "      <td>19.30</td>\n",
       "      <td>253313.17</td>\n",
       "      <td>22.10</td>\n",
       "      <td>41646.21</td>\n",
       "      <td>16.60</td>\n",
       "      <td>211666.96</td>\n",
       "      <td>--</td>\n",
       "      <td>446463.57</td>\n",
       "      <td>--</td>\n",
       "      <td>138357.86</td>\n",
       "      <td>--</td>\n",
       "      <td>292037.71</td>\n",
       "      <td>--</td>\n",
       "      <td>16068.00</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>2010.9</td>\n",
       "      <td>696471.50</td>\n",
       "      <td>18.96</td>\n",
       "      <td>243821.90</td>\n",
       "      <td>20.87</td>\n",
       "      <td>41854.41</td>\n",
       "      <td>13.78</td>\n",
       "      <td>201967.50</td>\n",
       "      <td>22.45</td>\n",
       "      <td>452649.59</td>\n",
       "      <td>17.95</td>\n",
       "      <td>142865.49</td>\n",
       "      <td>28.43</td>\n",
       "      <td>299136.35</td>\n",
       "      <td>17.01</td>\n",
       "      <td>10647.75</td>\n",
       "      <td>3.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>2010.8</td>\n",
       "      <td>687506.92</td>\n",
       "      <td>19.20</td>\n",
       "      <td>244340.64</td>\n",
       "      <td>21.90</td>\n",
       "      <td>39922.76</td>\n",
       "      <td>16.00</td>\n",
       "      <td>204417.88</td>\n",
       "      <td>--</td>\n",
       "      <td>443166.28</td>\n",
       "      <td>--</td>\n",
       "      <td>134975.20</td>\n",
       "      <td>--</td>\n",
       "      <td>288773.09</td>\n",
       "      <td>--</td>\n",
       "      <td>19417.99</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>2010.7</td>\n",
       "      <td>674051.48</td>\n",
       "      <td>17.60</td>\n",
       "      <td>240664.07</td>\n",
       "      <td>22.90</td>\n",
       "      <td>39543.16</td>\n",
       "      <td>15.50</td>\n",
       "      <td>201120.91</td>\n",
       "      <td>--</td>\n",
       "      <td>433387.41</td>\n",
       "      <td>--</td>\n",
       "      <td>131100.16</td>\n",
       "      <td>--</td>\n",
       "      <td>286989.41</td>\n",
       "      <td>--</td>\n",
       "      <td>15297.84</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>2010.6</td>\n",
       "      <td>673921.72</td>\n",
       "      <td>18.46</td>\n",
       "      <td>240580.00</td>\n",
       "      <td>24.56</td>\n",
       "      <td>38904.85</td>\n",
       "      <td>15.65</td>\n",
       "      <td>201675.15</td>\n",
       "      <td>26.44</td>\n",
       "      <td>433341.73</td>\n",
       "      <td>--</td>\n",
       "      <td>131673.96</td>\n",
       "      <td>--</td>\n",
       "      <td>287474.10</td>\n",
       "      <td>--</td>\n",
       "      <td>14193.66</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>2010.5</td>\n",
       "      <td>663351.37</td>\n",
       "      <td>21.00</td>\n",
       "      <td>236497.88</td>\n",
       "      <td>29.90</td>\n",
       "      <td>38652.97</td>\n",
       "      <td>15.20</td>\n",
       "      <td>197844.91</td>\n",
       "      <td>--</td>\n",
       "      <td>426853.49</td>\n",
       "      <td>--</td>\n",
       "      <td>130292.50</td>\n",
       "      <td>--</td>\n",
       "      <td>280547.60</td>\n",
       "      <td>--</td>\n",
       "      <td>16013.39</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>2010.4</td>\n",
       "      <td>656561.22</td>\n",
       "      <td>21.48</td>\n",
       "      <td>233909.76</td>\n",
       "      <td>31.25</td>\n",
       "      <td>39657.54</td>\n",
       "      <td>15.76</td>\n",
       "      <td>194252.22</td>\n",
       "      <td>--</td>\n",
       "      <td>422651.46</td>\n",
       "      <td>--</td>\n",
       "      <td>127802.17</td>\n",
       "      <td>--</td>\n",
       "      <td>279852.51</td>\n",
       "      <td>--</td>\n",
       "      <td>14996.77</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>2010.3</td>\n",
       "      <td>649947.46</td>\n",
       "      <td>22.50</td>\n",
       "      <td>229397.93</td>\n",
       "      <td>29.94</td>\n",
       "      <td>39080.58</td>\n",
       "      <td>15.81</td>\n",
       "      <td>190317.35</td>\n",
       "      <td>33.28</td>\n",
       "      <td>420549.53</td>\n",
       "      <td>18.79</td>\n",
       "      <td>122943.73</td>\n",
       "      <td>33.71</td>\n",
       "      <td>280350.33</td>\n",
       "      <td>15.62</td>\n",
       "      <td>17255.48</td>\n",
       "      <td>12.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>2010.2</td>\n",
       "      <td>636072.26</td>\n",
       "      <td>25.52</td>\n",
       "      <td>224286.95</td>\n",
       "      <td>34.99</td>\n",
       "      <td>42865.79</td>\n",
       "      <td>21.98</td>\n",
       "      <td>181421.17</td>\n",
       "      <td>--</td>\n",
       "      <td>411785.31</td>\n",
       "      <td>--</td>\n",
       "      <td>119190.13</td>\n",
       "      <td>--</td>\n",
       "      <td>278352.29</td>\n",
       "      <td>--</td>\n",
       "      <td>14242.89</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       month         m2 m2_yoy         m1 m1_yoy        m0 m0_yoy         cd  \\\n",
       "90   2010.12  725851.79  19.72  266621.54  21.19  44628.17  16.69  221993.37   \n",
       "91   2010.11  710339.02  19.50  259420.32  22.10  42252.16  16.30  217168.16   \n",
       "92   2010.10  699776.74  19.30  253313.17  22.10  41646.21  16.60  211666.96   \n",
       "93    2010.9  696471.50  18.96  243821.90  20.87  41854.41  13.78  201967.50   \n",
       "94    2010.8  687506.92  19.20  244340.64  21.90  39922.76  16.00  204417.88   \n",
       "95    2010.7  674051.48  17.60  240664.07  22.90  39543.16  15.50  201120.91   \n",
       "96    2010.6  673921.72  18.46  240580.00  24.56  38904.85  15.65  201675.15   \n",
       "97    2010.5  663351.37  21.00  236497.88  29.90  38652.97  15.20  197844.91   \n",
       "98    2010.4  656561.22  21.48  233909.76  31.25  39657.54  15.76  194252.22   \n",
       "99    2010.3  649947.46  22.50  229397.93  29.94  39080.58  15.81  190317.35   \n",
       "100   2010.2  636072.26  25.52  224286.95  34.99  42865.79  21.98  181421.17   \n",
       "\n",
       "    cd_yoy         qm qm_yoy        ftd ftd_yoy         sd sd_yoy     rests  \\\n",
       "90   22.14  459230.25  18.88  143232.08   28.65  303093.01  16.31  12905.15   \n",
       "91      --  450918.70     --  140202.84      --  293426.73     --  17289.13   \n",
       "92      --  446463.57     --  138357.86      --  292037.71     --  16068.00   \n",
       "93   22.45  452649.59  17.95  142865.49   28.43  299136.35  17.01  10647.75   \n",
       "94      --  443166.28     --  134975.20      --  288773.09     --  19417.99   \n",
       "95      --  433387.41     --  131100.16      --  286989.41     --  15297.84   \n",
       "96   26.44  433341.73     --  131673.96      --  287474.10     --  14193.66   \n",
       "97      --  426853.49     --  130292.50      --  280547.60     --  16013.39   \n",
       "98      --  422651.46     --  127802.17      --  279852.51     --  14996.77   \n",
       "99   33.28  420549.53  18.79  122943.73   33.71  280350.33  15.62  17255.48   \n",
       "100     --  411785.31     --  119190.13      --  278352.29     --  14242.89   \n",
       "\n",
       "    rests_yoy  \n",
       "90      15.81  \n",
       "91         --  \n",
       "92         --  \n",
       "93       3.58  \n",
       "94         --  \n",
       "95         --  \n",
       "96         --  \n",
       "97         --  \n",
       "98         --  \n",
       "99      12.86  \n",
       "100        --  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df3.loc[90:100,:]#( 序号90-100，所有列)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>m2</th>\n",
       "      <th>m2_yoy</th>\n",
       "      <th>m1</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>636072.26</td>\n",
       "      <td>25.52</td>\n",
       "      <td>224286.95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>625609.29</td>\n",
       "      <td>25.98</td>\n",
       "      <td>229588.98</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>610224.52</td>\n",
       "      <td>27.68</td>\n",
       "      <td>221445.81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>594604.72</td>\n",
       "      <td>29.74</td>\n",
       "      <td>212493.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>586643.29</td>\n",
       "      <td>29.42</td>\n",
       "      <td>207545.74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>105</th>\n",
       "      <td>585405.34</td>\n",
       "      <td>29.31</td>\n",
       "      <td>201708.14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106</th>\n",
       "      <td>576698.95</td>\n",
       "      <td>28.53</td>\n",
       "      <td>200394.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107</th>\n",
       "      <td>573102.85</td>\n",
       "      <td>28.42</td>\n",
       "      <td>195889.26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>108</th>\n",
       "      <td>568916.20</td>\n",
       "      <td>28.46</td>\n",
       "      <td>193138.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>548263.51</td>\n",
       "      <td>25.74</td>\n",
       "      <td>182025.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110</th>\n",
       "      <td>540481.21</td>\n",
       "      <td>25.95</td>\n",
       "      <td>178213.57</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            m2 m2_yoy         m1\n",
       "100  636072.26  25.52  224286.95\n",
       "101  625609.29  25.98  229588.98\n",
       "102  610224.52  27.68  221445.81\n",
       "103  594604.72  29.74  212493.20\n",
       "104  586643.29  29.42  207545.74\n",
       "105  585405.34  29.31  201708.14\n",
       "106  576698.95  28.53  200394.83\n",
       "107  573102.85  28.42  195889.26\n",
       "108  568916.20  28.46  193138.15\n",
       "109  548263.51  25.74  182025.58\n",
       "110  540481.21  25.95  178213.57"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df3.loc[100:110,\"m2\":\"m1\"]#( 序号100-110行，列号m2-m1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "month :统计时间\n",
    "m2 :货币和准货币（广义货币M2）(亿元)\n",
    "m2_yoy:货币和准货币（广义货币M2）同比增长(%)\n",
    "m1:货币(狭义货币M1)(亿元)\n",
    "m1_yoy:货币(狭义货币M1)同比增长(%)\n",
    "m0:流通中现金(M0)(亿元)\n",
    "m0_yoy:流通中现金(M0)同比增长(%)\n",
    "cd:活期存款(亿元)\n",
    "cd_yoy:活期存款同比增长(%)\n",
    "qm:准货币(亿元)\n",
    "qm_yoy:准货币同比增长(%)\n",
    "ftd:定期存款(亿元)\n",
    "ftd_yoy:定期存款同比增长(%)\n",
    "sd:储蓄存款(亿元)\n",
    "sd_yoy:储蓄存款同比增长(%)\n",
    "rests:其他存款(亿元)\n",
    "rests_yoy:其他存款同比增长(%)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "df3=ts.get_money_supply_bal()#货币供应量年底余额\n",
    "df3.to_csv(\"moneysupply余额.csv\")#保存文件"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>date</th>\n",
       "      <th>loan_type</th>\n",
       "      <th>rate</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2015-10-24</td>\n",
       "      <td>短期贷款(六个月以内)</td>\n",
       "      <td>4.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2015-10-24</td>\n",
       "      <td>短期贷款(六个月至一年)</td>\n",
       "      <td>4.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2015-10-24</td>\n",
       "      <td>中长期贷款(三至五年)</td>\n",
       "      <td>4.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2015-10-24</td>\n",
       "      <td>中长期贷款(五年以上)</td>\n",
       "      <td>4.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2015-10-24</td>\n",
       "      <td>中长期贷款(一至三年)</td>\n",
       "      <td>4.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2015-10-24</td>\n",
       "      <td>贴现(贴现)</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2015-10-24</td>\n",
       "      <td>优惠贷款(扶贫贴息贷款)</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2015-10-24</td>\n",
       "      <td>优惠贷款(老少边穷发展经济贷款)</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2015-10-24</td>\n",
       "      <td>优惠贷款(民政部门福利工厂贷款)</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2015-10-24</td>\n",
       "      <td>优惠贷款(民族贸易及民族用品生产贷款)</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2015-10-24</td>\n",
       "      <td>优惠贷款(贫困县办工业贷款)</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2015-10-24</td>\n",
       "      <td>个人住房商业贷款(六个月以内)</td>\n",
       "      <td>3.92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2015-10-24</td>\n",
       "      <td>个人住房商业贷款(六个月至一年)</td>\n",
       "      <td>3.92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2015-10-24</td>\n",
       "      <td>个人住房商业贷款(三至五年)</td>\n",
       "      <td>4.28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2015-10-24</td>\n",
       "      <td>个人住房商业贷款(五年以上)</td>\n",
       "      <td>4.41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2015-10-24</td>\n",
       "      <td>个人住房商业贷款(一至三年)</td>\n",
       "      <td>4.28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2015-10-24</td>\n",
       "      <td>个人住房公积金贷款(五年以上)</td>\n",
       "      <td>3.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2015-10-24</td>\n",
       "      <td>个人住房公积金贷款(五年以下)</td>\n",
       "      <td>2.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2015-09-06</td>\n",
       "      <td>再贴现(再贴现率)</td>\n",
       "      <td>2.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2015-08-26</td>\n",
       "      <td>短期贷款(六个月以内)</td>\n",
       "      <td>4.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2015-08-26</td>\n",
       "      <td>短期贷款(六个月至一年)</td>\n",
       "      <td>4.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2015-08-26</td>\n",
       "      <td>中长期贷款(三至五年)</td>\n",
       "      <td>5.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2015-08-26</td>\n",
       "      <td>中长期贷款(五年以上)</td>\n",
       "      <td>5.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2015-08-26</td>\n",
       "      <td>中长期贷款(一至三年)</td>\n",
       "      <td>5.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2015-08-26</td>\n",
       "      <td>贴现(贴现)</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2015-08-26</td>\n",
       "      <td>优惠贷款(扶贫贴息贷款)</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2015-08-26</td>\n",
       "      <td>优惠贷款(老少边穷发展经济贷款)</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2015-08-26</td>\n",
       "      <td>优惠贷款(民政部门福利工厂贷款)</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2015-08-26</td>\n",
       "      <td>优惠贷款(民族贸易及民族用品生产贷款)</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2015-08-26</td>\n",
       "      <td>优惠贷款(贫困县办工业贷款)</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>770</th>\n",
       "      <td>1993-05-15</td>\n",
       "      <td>个人住房公积金贷款(五年以上)</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>771</th>\n",
       "      <td>1993-05-15</td>\n",
       "      <td>个人住房公积金贷款(五年以下)</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>772</th>\n",
       "      <td>1993-05-12</td>\n",
       "      <td>特种贷款(特种贷款利率)</td>\n",
       "      <td>11.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>773</th>\n",
       "      <td>1991-04-21</td>\n",
       "      <td>短期贷款(六个月以内)</td>\n",
       "      <td>8.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>774</th>\n",
       "      <td>1991-04-21</td>\n",
       "      <td>短期贷款(六个月至一年)</td>\n",
       "      <td>8.64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>775</th>\n",
       "      <td>1991-04-21</td>\n",
       "      <td>中长期贷款(三至五年)</td>\n",
       "      <td>9.54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>776</th>\n",
       "      <td>1991-04-21</td>\n",
       "      <td>中长期贷款(五年以上)</td>\n",
       "      <td>9.72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>777</th>\n",
       "      <td>1991-04-21</td>\n",
       "      <td>中长期贷款(一至三年)</td>\n",
       "      <td>9.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>778</th>\n",
       "      <td>1991-04-21</td>\n",
       "      <td>贴现(贴现)</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>779</th>\n",
       "      <td>1991-04-21</td>\n",
       "      <td>优惠贷款(扶贫贴息贷款)</td>\n",
       "      <td>2.88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>780</th>\n",
       "      <td>1991-04-21</td>\n",
       "      <td>优惠贷款(老少边穷发展经济贷款)</td>\n",
       "      <td>5.76</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>781</th>\n",
       "      <td>1991-04-21</td>\n",
       "      <td>优惠贷款(民政部门福利工厂贷款)</td>\n",
       "      <td>7.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>782</th>\n",
       "      <td>1991-04-21</td>\n",
       "      <td>优惠贷款(民族贸易及民族用品生产贷款)</td>\n",
       "      <td>5.76</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>783</th>\n",
       "      <td>1991-04-21</td>\n",
       "      <td>优惠贷款(贫困县办工业贷款)</td>\n",
       "      <td>5.76</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>784</th>\n",
       "      <td>1991-04-21</td>\n",
       "      <td>个人住房商业贷款(六个月以内)</td>\n",
       "      <td>7.29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>785</th>\n",
       "      <td>1991-04-21</td>\n",
       "      <td>个人住房商业贷款(六个月至一年)</td>\n",
       "      <td>7.78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>786</th>\n",
       "      <td>1991-04-21</td>\n",
       "      <td>个人住房商业贷款(三至五年)</td>\n",
       "      <td>8.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>787</th>\n",
       "      <td>1991-04-21</td>\n",
       "      <td>个人住房商业贷款(五年以上)</td>\n",
       "      <td>8.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>788</th>\n",
       "      <td>1991-04-21</td>\n",
       "      <td>个人住房商业贷款(一至三年)</td>\n",
       "      <td>8.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>789</th>\n",
       "      <td>1991-04-21</td>\n",
       "      <td>个人住房公积金贷款(五年以上)</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>790</th>\n",
       "      <td>1991-04-21</td>\n",
       "      <td>个人住房公积金贷款(五年以下)</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>791</th>\n",
       "      <td>1991-04-21</td>\n",
       "      <td>特种贷款(特种贷款利率)</td>\n",
       "      <td>9.72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>792</th>\n",
       "      <td>1990-08-21</td>\n",
       "      <td>短期贷款(六个月以内)</td>\n",
       "      <td>8.64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>793</th>\n",
       "      <td>1990-08-21</td>\n",
       "      <td>短期贷款(六个月至一年)</td>\n",
       "      <td>9.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>794</th>\n",
       "      <td>1990-08-21</td>\n",
       "      <td>中长期贷款(三至五年)</td>\n",
       "      <td>10.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>795</th>\n",
       "      <td>1990-08-21</td>\n",
       "      <td>中长期贷款(五年以上)</td>\n",
       "      <td>11.16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>796</th>\n",
       "      <td>1990-08-21</td>\n",
       "      <td>中长期贷款(一至三年)</td>\n",
       "      <td>10.08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>797</th>\n",
       "      <td>1990-08-21</td>\n",
       "      <td>贴现(贴现)</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>798</th>\n",
       "      <td>1990-08-21</td>\n",
       "      <td>优惠贷款(扶贫贴息贷款)</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>799</th>\n",
       "      <td>1990-08-21</td>\n",
       "      <td>优惠贷款(老少边穷发展经济贷款)</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>800 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           date            loan_type   rate\n",
       "0    2015-10-24          短期贷款(六个月以内)   4.35\n",
       "1    2015-10-24         短期贷款(六个月至一年)   4.35\n",
       "2    2015-10-24          中长期贷款(三至五年)   4.75\n",
       "3    2015-10-24          中长期贷款(五年以上)   4.90\n",
       "4    2015-10-24          中长期贷款(一至三年)   4.75\n",
       "5    2015-10-24               贴现(贴现)     --\n",
       "6    2015-10-24         优惠贷款(扶贫贴息贷款)     --\n",
       "7    2015-10-24     优惠贷款(老少边穷发展经济贷款)     --\n",
       "8    2015-10-24     优惠贷款(民政部门福利工厂贷款)     --\n",
       "9    2015-10-24  优惠贷款(民族贸易及民族用品生产贷款)     --\n",
       "10   2015-10-24       优惠贷款(贫困县办工业贷款)     --\n",
       "11   2015-10-24      个人住房商业贷款(六个月以内)   3.92\n",
       "12   2015-10-24     个人住房商业贷款(六个月至一年)   3.92\n",
       "13   2015-10-24       个人住房商业贷款(三至五年)   4.28\n",
       "14   2015-10-24       个人住房商业贷款(五年以上)   4.41\n",
       "15   2015-10-24       个人住房商业贷款(一至三年)   4.28\n",
       "16   2015-10-24      个人住房公积金贷款(五年以上)   3.25\n",
       "17   2015-10-24      个人住房公积金贷款(五年以下)   2.75\n",
       "18   2015-09-06            再贴现(再贴现率)   2.25\n",
       "19   2015-08-26          短期贷款(六个月以内)   4.60\n",
       "20   2015-08-26         短期贷款(六个月至一年)   4.60\n",
       "21   2015-08-26          中长期贷款(三至五年)   5.00\n",
       "22   2015-08-26          中长期贷款(五年以上)   5.15\n",
       "23   2015-08-26          中长期贷款(一至三年)   5.00\n",
       "24   2015-08-26               贴现(贴现)     --\n",
       "25   2015-08-26         优惠贷款(扶贫贴息贷款)     --\n",
       "26   2015-08-26     优惠贷款(老少边穷发展经济贷款)     --\n",
       "27   2015-08-26     优惠贷款(民政部门福利工厂贷款)     --\n",
       "28   2015-08-26  优惠贷款(民族贸易及民族用品生产贷款)     --\n",
       "29   2015-08-26       优惠贷款(贫困县办工业贷款)     --\n",
       "..          ...                  ...    ...\n",
       "770  1993-05-15      个人住房公积金贷款(五年以上)     --\n",
       "771  1993-05-15      个人住房公积金贷款(五年以下)     --\n",
       "772  1993-05-12         特种贷款(特种贷款利率)  11.25\n",
       "773  1991-04-21          短期贷款(六个月以内)   8.10\n",
       "774  1991-04-21         短期贷款(六个月至一年)   8.64\n",
       "775  1991-04-21          中长期贷款(三至五年)   9.54\n",
       "776  1991-04-21          中长期贷款(五年以上)   9.72\n",
       "777  1991-04-21          中长期贷款(一至三年)   9.00\n",
       "778  1991-04-21               贴现(贴现)     --\n",
       "779  1991-04-21         优惠贷款(扶贫贴息贷款)   2.88\n",
       "780  1991-04-21     优惠贷款(老少边穷发展经济贷款)   5.76\n",
       "781  1991-04-21     优惠贷款(民政部门福利工厂贷款)   7.20\n",
       "782  1991-04-21  优惠贷款(民族贸易及民族用品生产贷款)   5.76\n",
       "783  1991-04-21       优惠贷款(贫困县办工业贷款)   5.76\n",
       "784  1991-04-21      个人住房商业贷款(六个月以内)   7.29\n",
       "785  1991-04-21     个人住房商业贷款(六个月至一年)   7.78\n",
       "786  1991-04-21       个人住房商业贷款(三至五年)   8.59\n",
       "787  1991-04-21       个人住房商业贷款(五年以上)   8.75\n",
       "788  1991-04-21       个人住房商业贷款(一至三年)   8.10\n",
       "789  1991-04-21      个人住房公积金贷款(五年以上)     --\n",
       "790  1991-04-21      个人住房公积金贷款(五年以下)     --\n",
       "791  1991-04-21         特种贷款(特种贷款利率)   9.72\n",
       "792  1990-08-21          短期贷款(六个月以内)   8.64\n",
       "793  1990-08-21         短期贷款(六个月至一年)   9.36\n",
       "794  1990-08-21          中长期贷款(三至五年)  10.80\n",
       "795  1990-08-21          中长期贷款(五年以上)  11.16\n",
       "796  1990-08-21          中长期贷款(一至三年)  10.08\n",
       "797  1990-08-21               贴现(贴现)     --\n",
       "798  1990-08-21         优惠贷款(扶贫贴息贷款)     --\n",
       "799  1990-08-21     优惠贷款(老少边穷发展经济贷款)     --\n",
       "\n",
       "[800 rows x 3 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ts.get_loan_rate()#贷款利率"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>date</th>\n",
       "      <th>deposit_type</th>\n",
       "      <th>rate</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2015-10-24</td>\n",
       "      <td>定活两便(定期)</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2015-10-24</td>\n",
       "      <td>定期存款整存整取(半年)</td>\n",
       "      <td>1.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2015-10-24</td>\n",
       "      <td>定期存款整存整取(二年)</td>\n",
       "      <td>2.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2015-10-24</td>\n",
       "      <td>定期存款整存整取(三个月)</td>\n",
       "      <td>1.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2015-10-24</td>\n",
       "      <td>定期存款整存整取(三年)</td>\n",
       "      <td>2.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2015-10-24</td>\n",
       "      <td>定期存款整存整取(五年)</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2015-10-24</td>\n",
       "      <td>定期存款整存整取(一年)</td>\n",
       "      <td>1.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2015-10-24</td>\n",
       "      <td>活期存款(不定期)</td>\n",
       "      <td>0.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2015-10-24</td>\n",
       "      <td>零存整取、整存零取、存本取息定期存款(三年)</td>\n",
       "      <td>1.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2015-10-24</td>\n",
       "      <td>零存整取、整存零取、存本取息定期存款(五年)</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2015-10-24</td>\n",
       "      <td>零存整取、整存零取、存本取息定期存款(一年)</td>\n",
       "      <td>1.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2015-10-24</td>\n",
       "      <td>通知存款(七天)</td>\n",
       "      <td>1.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2015-10-24</td>\n",
       "      <td>通知存款(一天)</td>\n",
       "      <td>0.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2015-10-24</td>\n",
       "      <td>协定存款(定期)</td>\n",
       "      <td>1.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2015-08-26</td>\n",
       "      <td>定活两便(定期)</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2015-08-26</td>\n",
       "      <td>定期存款整存整取(半年)</td>\n",
       "      <td>1.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2015-08-26</td>\n",
       "      <td>定期存款整存整取(二年)</td>\n",
       "      <td>2.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2015-08-26</td>\n",
       "      <td>定期存款整存整取(三个月)</td>\n",
       "      <td>1.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2015-08-26</td>\n",
       "      <td>定期存款整存整取(三年)</td>\n",
       "      <td>3.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2015-08-26</td>\n",
       "      <td>定期存款整存整取(五年)</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2015-08-26</td>\n",
       "      <td>定期存款整存整取(一年)</td>\n",
       "      <td>1.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2015-08-26</td>\n",
       "      <td>活期存款(不定期)</td>\n",
       "      <td>0.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2015-08-26</td>\n",
       "      <td>零存整取、整存零取、存本取息定期存款(三年)</td>\n",
       "      <td>1.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2015-08-26</td>\n",
       "      <td>零存整取、整存零取、存本取息定期存款(五年)</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2015-08-26</td>\n",
       "      <td>零存整取、整存零取、存本取息定期存款(一年)</td>\n",
       "      <td>1.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2015-08-26</td>\n",
       "      <td>通知存款(七天)</td>\n",
       "      <td>1.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2015-08-26</td>\n",
       "      <td>通知存款(一天)</td>\n",
       "      <td>0.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2015-08-26</td>\n",
       "      <td>协定存款(定期)</td>\n",
       "      <td>1.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2015-06-28</td>\n",
       "      <td>定活两便(定期)</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2015-06-28</td>\n",
       "      <td>定期存款整存整取(半年)</td>\n",
       "      <td>1.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>516</th>\n",
       "      <td>1990-08-21</td>\n",
       "      <td>通知存款(一天)</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>517</th>\n",
       "      <td>1990-08-21</td>\n",
       "      <td>协定存款(定期)</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>518</th>\n",
       "      <td>1990-04-15</td>\n",
       "      <td>定活两便(定期)</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>519</th>\n",
       "      <td>1990-04-15</td>\n",
       "      <td>定期存款整存整取(半年)</td>\n",
       "      <td>7.74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>520</th>\n",
       "      <td>1990-04-15</td>\n",
       "      <td>定期存款整存整取(二年)</td>\n",
       "      <td>11.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>521</th>\n",
       "      <td>1990-04-15</td>\n",
       "      <td>定期存款整存整取(三个月)</td>\n",
       "      <td>6.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>522</th>\n",
       "      <td>1990-04-15</td>\n",
       "      <td>定期存款整存整取(三年)</td>\n",
       "      <td>11.88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>523</th>\n",
       "      <td>1990-04-15</td>\n",
       "      <td>定期存款整存整取(五年)</td>\n",
       "      <td>13.68</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>524</th>\n",
       "      <td>1990-04-15</td>\n",
       "      <td>定期存款整存整取(一年)</td>\n",
       "      <td>10.08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>525</th>\n",
       "      <td>1990-04-15</td>\n",
       "      <td>活期存款(不定期)</td>\n",
       "      <td>2.88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>526</th>\n",
       "      <td>1990-04-15</td>\n",
       "      <td>零存整取、整存零取、存本取息定期存款(三年)</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>527</th>\n",
       "      <td>1990-04-15</td>\n",
       "      <td>零存整取、整存零取、存本取息定期存款(五年)</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>528</th>\n",
       "      <td>1990-04-15</td>\n",
       "      <td>零存整取、整存零取、存本取息定期存款(一年)</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>529</th>\n",
       "      <td>1990-04-15</td>\n",
       "      <td>通知存款(七天)</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>530</th>\n",
       "      <td>1990-04-15</td>\n",
       "      <td>通知存款(一天)</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>531</th>\n",
       "      <td>1990-04-15</td>\n",
       "      <td>协定存款(定期)</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>532</th>\n",
       "      <td>1989-02-01</td>\n",
       "      <td>定活两便(定期)</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>533</th>\n",
       "      <td>1989-02-01</td>\n",
       "      <td>定期存款整存整取(半年)</td>\n",
       "      <td>9.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>534</th>\n",
       "      <td>1989-02-01</td>\n",
       "      <td>定期存款整存整取(二年)</td>\n",
       "      <td>12.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>535</th>\n",
       "      <td>1989-02-01</td>\n",
       "      <td>定期存款整存整取(三个月)</td>\n",
       "      <td>7.56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>536</th>\n",
       "      <td>1989-02-01</td>\n",
       "      <td>定期存款整存整取(三年)</td>\n",
       "      <td>13.14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>537</th>\n",
       "      <td>1989-02-01</td>\n",
       "      <td>定期存款整存整取(五年)</td>\n",
       "      <td>14.94</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>538</th>\n",
       "      <td>1989-02-01</td>\n",
       "      <td>定期存款整存整取(一年)</td>\n",
       "      <td>11.34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>539</th>\n",
       "      <td>1989-02-01</td>\n",
       "      <td>活期存款(不定期)</td>\n",
       "      <td>2.88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>540</th>\n",
       "      <td>1989-02-01</td>\n",
       "      <td>零存整取、整存零取、存本取息定期存款(三年)</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541</th>\n",
       "      <td>1989-02-01</td>\n",
       "      <td>零存整取、整存零取、存本取息定期存款(五年)</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>542</th>\n",
       "      <td>1989-02-01</td>\n",
       "      <td>零存整取、整存零取、存本取息定期存款(一年)</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>543</th>\n",
       "      <td>1989-02-01</td>\n",
       "      <td>通知存款(七天)</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>544</th>\n",
       "      <td>1989-02-01</td>\n",
       "      <td>通知存款(一天)</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>545</th>\n",
       "      <td>1989-02-01</td>\n",
       "      <td>协定存款(定期)</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>546 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           date            deposit_type   rate\n",
       "0    2015-10-24                定活两便(定期)     --\n",
       "1    2015-10-24            定期存款整存整取(半年)   1.30\n",
       "2    2015-10-24            定期存款整存整取(二年)   2.10\n",
       "3    2015-10-24           定期存款整存整取(三个月)   1.10\n",
       "4    2015-10-24            定期存款整存整取(三年)   2.75\n",
       "5    2015-10-24            定期存款整存整取(五年)     --\n",
       "6    2015-10-24            定期存款整存整取(一年)   1.50\n",
       "7    2015-10-24               活期存款(不定期)   0.35\n",
       "8    2015-10-24  零存整取、整存零取、存本取息定期存款(三年)   1.30\n",
       "9    2015-10-24  零存整取、整存零取、存本取息定期存款(五年)     --\n",
       "10   2015-10-24  零存整取、整存零取、存本取息定期存款(一年)   1.10\n",
       "11   2015-10-24                通知存款(七天)   1.35\n",
       "12   2015-10-24                通知存款(一天)   0.80\n",
       "13   2015-10-24                协定存款(定期)   1.15\n",
       "14   2015-08-26                定活两便(定期)     --\n",
       "15   2015-08-26            定期存款整存整取(半年)   1.55\n",
       "16   2015-08-26            定期存款整存整取(二年)   2.35\n",
       "17   2015-08-26           定期存款整存整取(三个月)   1.35\n",
       "18   2015-08-26            定期存款整存整取(三年)   3.00\n",
       "19   2015-08-26            定期存款整存整取(五年)     --\n",
       "20   2015-08-26            定期存款整存整取(一年)   1.75\n",
       "21   2015-08-26               活期存款(不定期)   0.35\n",
       "22   2015-08-26  零存整取、整存零取、存本取息定期存款(三年)   1.55\n",
       "23   2015-08-26  零存整取、整存零取、存本取息定期存款(五年)     --\n",
       "24   2015-08-26  零存整取、整存零取、存本取息定期存款(一年)   1.35\n",
       "25   2015-08-26                通知存款(七天)   1.35\n",
       "26   2015-08-26                通知存款(一天)   0.80\n",
       "27   2015-08-26                协定存款(定期)   1.15\n",
       "28   2015-06-28                定活两便(定期)     --\n",
       "29   2015-06-28            定期存款整存整取(半年)   1.80\n",
       "..          ...                     ...    ...\n",
       "516  1990-08-21                通知存款(一天)     --\n",
       "517  1990-08-21                协定存款(定期)     --\n",
       "518  1990-04-15                定活两便(定期)     --\n",
       "519  1990-04-15            定期存款整存整取(半年)   7.74\n",
       "520  1990-04-15            定期存款整存整取(二年)  11.00\n",
       "521  1990-04-15           定期存款整存整取(三个月)   6.30\n",
       "522  1990-04-15            定期存款整存整取(三年)  11.88\n",
       "523  1990-04-15            定期存款整存整取(五年)  13.68\n",
       "524  1990-04-15            定期存款整存整取(一年)  10.08\n",
       "525  1990-04-15               活期存款(不定期)   2.88\n",
       "526  1990-04-15  零存整取、整存零取、存本取息定期存款(三年)     --\n",
       "527  1990-04-15  零存整取、整存零取、存本取息定期存款(五年)     --\n",
       "528  1990-04-15  零存整取、整存零取、存本取息定期存款(一年)     --\n",
       "529  1990-04-15                通知存款(七天)     --\n",
       "530  1990-04-15                通知存款(一天)     --\n",
       "531  1990-04-15                协定存款(定期)     --\n",
       "532  1989-02-01                定活两便(定期)     --\n",
       "533  1989-02-01            定期存款整存整取(半年)   9.00\n",
       "534  1989-02-01            定期存款整存整取(二年)  12.20\n",
       "535  1989-02-01           定期存款整存整取(三个月)   7.56\n",
       "536  1989-02-01            定期存款整存整取(三年)  13.14\n",
       "537  1989-02-01            定期存款整存整取(五年)  14.94\n",
       "538  1989-02-01            定期存款整存整取(一年)  11.34\n",
       "539  1989-02-01               活期存款(不定期)   2.88\n",
       "540  1989-02-01  零存整取、整存零取、存本取息定期存款(三年)     --\n",
       "541  1989-02-01  零存整取、整存零取、存本取息定期存款(五年)     --\n",
       "542  1989-02-01  零存整取、整存零取、存本取息定期存款(一年)     --\n",
       "543  1989-02-01                通知存款(七天)     --\n",
       "544  1989-02-01                通知存款(一天)     --\n",
       "545  1989-02-01                协定存款(定期)     --\n",
       "\n",
       "[546 rows x 3 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ts.get__rate()#存款利率"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "ts.get_rrr()#存款准备金"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "ts.get_gdp_year()#国内生产总值"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "ts.get_gdp_year()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "ts.get_gdp_quarter()#每季度国内生产总值"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "ts.get_gdp_for()#投资出口内需对GDP贡献"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "year :统计年度\n",
    "end_for :最终消费支出贡献率(%)\n",
    "for_rate :最终消费支出拉动(百分点)\n",
    "asset_for :资本形成总额贡献率(%)\n",
    "asset_rate:资本形成总额拉动(百分点)\n",
    "goods_for :货物和服务净出口贡献率(%)\n",
    "goods_rate :货物和服务净出口拉动(百分点)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "ts.get_gdp_pull()#三大产业对GDP增长率拉动构成"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "year :统计年度\n",
    "gdp_yoy :国内生产总值同比增长(%)\n",
    "pi :第一产业拉动率(%)\n",
    "si :第二产业拉动率(%)\n",
    "industry:其中工业拉动(%)\n",
    "ti :第三产业拉动率(%)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "ts.get_gdp_contrib()#三大产业对GDP贡献"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "year :统计年度\n",
    "gdp_yoy :国内生产总值\n",
    "pi :第一产业献率(%)\n",
    "si :第二产业献率(%)\n",
    "industry:其中工业献率(%)\n",
    "ti :第三产业献率(%)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "ts.get_cpi()#每月cpi"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "ts.get_ppi()#每月ppi"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "p vmonth :统计月份\n",
    "ppiip :工业品出厂价格指数\n",
    "ppi :生产资料价格指数\n",
    "qm:采掘工业价格指数\n",
    "rmi:原材料工业价格指数\n",
    "pi:加工工业价格指数\n",
    "cg:生活资料价格指数\n",
    "food:食品类价格指数\n",
    "clothing:衣着类价格指数\n",
    "roeu:一般日用品价格指数\n",
    "dcg:耐用消费品价格"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "ts.get_industry_classified()#行业分类"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "ts.get_hs300s()#沪深300"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "ts.get_sz50s()#上证50\n",
    "ts.get_zz500s()#中证500"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
